Report this Job
Job Title: ETL ADF Developer (Remote)
Location: Remote (Atlanta, GA)
Duration: 6 Months+
Pay Rate: $85/hr
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 (link removed) 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.
GSK Solutions
