Job description
Azure ETL Developer
4-7 Years of Experience
We are looking for a Microsoft SQL ETL Developer to join our team to design, develop and implement solutions to bring together data from various disparate systems into a centralized location for reporting and operational support.
Responsibilities of this position include, but are not limited to:
- Define data collection methods, data models, types, and outlines the transformation process
- Design, develop and maintain daily/weekly/monthly processes that pull data from various systems, both internal and external, and loads into the enterprise operational data store
- Daily extract, transform, and load data from various systems into enterprise data warehouse
Qualifications:
- Experience reading data of various file types including but not limited to delimited and Excel files
- Experience designing and optimizing moderate to complex SQL queries involving table joins and correlated sub-queries
- Experience with Microsoft Azure components DevOps, ADLS, Databricks, CosmosDB, and/or equivalent cloud resources
- Experience building and maintaining data pipelines and datasets
- Scala and Python programming experience is a plus
- Must be proficient with SSIS, Stored Procedures, TSQL and TFS
- Ability to work effectively with remote teammates and users
- Excellent interpersonal skills with the ability to establish working relationships with individuals at varying levels within the organization
- Demonstrated integrity within a professional environment
- Ability to trace and troubleshoot data behavior and issues
- Ability to adapt to new situations
- Ability to work on several projects simultaneously with guidance
- Perform tasks within predefined guidelines and procedures as assigned by manager or project team
Required Experience
- 4+ years of database design and administration experience
- 4+ years of SQL ETL experience
- 3+ years of Azure ADLS/Synapse
- 3+ yeas of Azure ADF and Databricks
Other Desired Qualifications
- Experience with Microsoft’s Modern Data Warehouse Architecture a plus
- Strong problem solving and analytical skills
- Strong working experience with performance tuning and SQL instance troubleshooting
- Familiarity with Azure DevOps
#LI-JM4
Job ID:
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.