Job description

The COA is seeking a full stack Application, Database and ETL developer with strong C#, .NET, SQL Database Development, Data Integrations and Data Analytics, including ArcGIS Online experience. Candidate must also have strong SQL server experience and understanding of enterprise application architecture including Azure cloud development. This position will support the City of Atlanta's Mayor's Office to implement innovative and creative data-focused solutions that align to one or more of the Mayor's Strategic Pillars: One Safe city, A City of Opportunity for All, A City Built on the Future, and Effective & Ethical Government. The environment is fast paced and highly impactful. In addition to new efforts, this position will be supporting and developing based on an existing platform. This will require a strong knowledge of Progress Telerik.NET tools to minimize re-work. Application Development • Participate in full lifecycle development of software including analysis, design, coding, testing, implementation, deployment and support. • Consistently write, translate, and code software programs and applications according to specifications. • Employ best practices for designing scalable, extensible, secure applications. • Design and develop n-tier .NET MVC web applications, WPF applications, web APIs and web services, windows services and console applications using C#, [website], JavaScript technologies and SQL Server. • Design and develop both internal and external facing APIs/RESTful services for Enterprise Application Integration of applications hosted on premise and in the cloud. • Develop release management strategies and configure automated deployment packages for deploying application and database changes to QA, Staging and Production environments. • Configure and manage Azure DevOps for source control and automated build, test and deployment of developed software. • Perform unit testing and analyze application and database performance on new and existing programs for the purposes of correcting errors, isolating areas for improvement, resolving performance bottlenecks, and general debugging. • Assist with development team code reviews when necessary. • Create technical documents and artifacts for developed software products using Microsoft Visio, PowerPoint and Office. Database Development • Responsible for designing, coding, and implementing software solutions using modern techniques and programming language • Provides database development in creating specific applications for businesses • Provides general support on information technology to design, develop, execute, and maintain the database application systems, applying several RDBMS • Ensures research and innovation at all levels of the software development process • May participate in multiple projects simultaneously as a senior development team member • Functions as technical architect and Subject Matter Expert (SME) on enterprise related software systems • Performs the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, as well as relevant systems that are already existing • Performs administrative duties as well as some project management tasks. • Provide guidance and support to Application Developers • Assist with schema design, code review, SQL query tuning Azure Data Factory (ADF) ETL Development Responsible for creating Data orchestration with Azure Data Factory Pipelines & Dataflows. Key role is to understand the business requirements and implement the requirements using Azure Data Factory. Roles & Responsibilities: • Understand business requirement and actively provide inputs from Data perspective • Understand the underlying data and flow of data. • Build simple to complex pipelines & dataflows. • Should be able to implement modules that have security and authorization frameworks. • Recognize and adapt to the changes in processes as the project evolves in size and function. Knowledge, Skills & Abilities: • Expert level knowledge on Azure Data Factory • Advance knowledge of Azure SQL DB & Synapse Analytics, Power BI, SSIS, SSRS, T-SQL, Power Automate (primary) or Logic Apps. • Should be able to analyze and understand complex data • Knowledge of Azure data lake is required and Azure Services like Analysis Service, SQL Databases, Azure DevOps, CI/CD is a must. • Knowledge of master data management, data warehousing and business intelligence architecture. • Experience in data modeling and database design with excellent knowledge of SQL Server best practices. • Should have clear understanding of DW lifecycle and contribute in preparing Design documents, Unit Test plans, Code review reports. • Experience working in Agile environment (Scrum, Lean, Kanban) is a plus Data Visualization • Partner with department owners and data analysts to understand the business questions our customers have and the data that drive the insights • Visualize data in innovative ways to communicate complex concepts that tell a story in a simple way through graphs, charts, infographics, dashboards, and geographic visualization techniques • Partake in user interviews to gather feedback and develop insights to turn them into design concepts; validate designs using a variety of customer-driven methods • Partake in concept sessions and rapidly produce prototypes using sketches, mockups, and BI visualization tools • Provide continuous design support around in software development lifecycle • Advocate for and own the consistency of the design implementation as part of the product development process • Support occasional customer deliverables requiring data visualizations Overall Position Requirements • Bachelor's degree in engineering, computer science, information systems, or a related field from an accredited college or university is preferred. • 5+ years of experience designing/developing web applications for products using WPF, C#, JavaScript technologies ( Node, React) and SQL Server Design database schema, developing stored procedures (T-SQL). • Ability to complete all phases of SDLC including analysis, design, development, testing and support utilizing traditional waterfall and Scrum/Agile methodologies. • Progress Telerik.NET • Ability to innovate and provide functional applications with intuitive interfaces. • Proven analytical and problem-solving abilities. • Ability to interpret complex business requirements and encapsulate business logic/rules into reusable libraries. • Strong understanding and demonstrated usage of object-oriented design concepts. • Experience with software versioning and release management. • Ability to effectively prioritize and execute tasks in a high-pressure environment. • Experience working both independently and in a team-oriented, collaborative environment. • Excellent communication skills. Experience with the following is a plus: • Microsoft Azure or similar cloud technologies • Microservices/ API development • React/React Native • Responsive web site design • Javascript frameworks (React, Bootstrap) • Mobile Application development Progress Telerik.NET Budget Information Critical Hire Code (Assigned by Approver) Background Verification (Suppliers shall use Info Cubic (IC) for background verifications.) Instructions The completed Background Verification will be attached (via an automated feed) to the candidates user profile under the Attachments Section. Please make sure to always include the applicable proposal ID, contract ID, or requisition ID in the reference field when ordering. It is also very important to double check that the name on the order being requested matches the candidate's name in the Covendis system. Otherwise, the completed report will not be successfully uploaded to the candidates profile. Additional Background Verification Services (City of Atlanta) To be completed upon candidate selection: Global Monitor Check State Criminal Record verification (past 7 years covering each State in which the candidate has resided) Social Security Number Verification Federal Criminal Records Verification (past 7 years) Any additional requirements stated by the Agency on the requisition Education Verification Employment Verification Drug Screening MVR (Suppliers Only) To order, click on the link to the right: Order Additional Background Verification services Instructions (If Applicable) The completed Background Verification will be attached (via an automated feed) to the candidates user profile under the Attachments Section. Please make sure to always include the applicable proposal ID, contract ID, or requisition ID in the reference field when ordering. It is also very important to double check that the name on the order being requested matches the candidate's name in the Covendis system. Otherwise, the completed report will not be successfully uploaded to the candidates profile. Agency Certification(s) Please read and understand the following statement carefully: I understand that a person who enters into an agreement in restraint of trade or in restraint of free and open competition in any transaction with the state may, upon conviction thereof, be punished by imprisonment for not less than one nor more than five years pursuant to OCGA 16-10-22. I further agree that when there is a prior agreement or understanding between a vendor and a state agency or state employee regarding the acceptance of any offer, such conduct is collusive, fraudulent and in restraint of trade and in restraint of free and open competition on the part of both the vendor and the state agency or state employee. Do you agree with the above statement? I Agree Type Category

Requirements