Sr. Data Engineer || Hybrid work in Raleigh, NC || Need Local Only
About The Position
The Senior Data Engineer will lead the development and optimization of end-to-end data engineering solutions using Microsoft Azure Synapse Analytics for the Child Welfare Program. The role focuses on building data pipelines, analytics solutions, and cloud-based data platforms that meet business needs while supporting data accessibility, performance, and security. This is a contract assignment based in Raleigh, North Carolina, with hybrid work and a requirement that candidates be local. The position also involves developing and maintaining Synapse data models for reporting and analytics, creating ETL solutions that extract and transform Salesforce data, configuring Synapse workspaces and pipelines, and maintaining the data architecture. The engineer will collaborate with data engineers, analysts, and stakeholders on requirements, visualizations, and training for self-service BI tools.
Requirements
- At least 5 years of experience designing and optimizing scalable data pipelines using platforms such as Azure Synapse, Snowflake, or Databricks workflows.
- At least 3 years of strong Python or Scala proficiency for data processing.
- At least 7 years of advanced SQL query writing, performance tuning, and optimization experience.
- At least 4 years of data modeling and warehousing experience, including star and snowflake schemas.
- At least 5 years of ETL/ELT experience.
- At least 4 years of experience with the Azure Data Platform, including Azure Data Factory, Azure Data Lake, and Azure SQL Database.
- At least 4 years of familiarity with Event Hubs, Azure Stream Analytics, and Azure Functions.
- At least 1 year of experience with SQL, T-SQL, and data query optimization.
- At least 5 years of experience with cloud platforms such as AWS and Azure and associated data processing and storage services.
- Provide two recent professional references from a Senior Manager or Director who oversaw the candidate's work before final selection.
- List professional certifications for data engineering platforms such as Azure Synapse, Databricks, and Snowflake, including the year received; certifications will be validated.
- Provide a brief description of recent professional development work with Azure Synapse Analytics, Databricks, or Snowflake.
- Candidates must be local to Raleigh, North Carolina.
- Resume submission should include consultant location and visa status.
Nice To Haves
- At least 1 year of experience with Power BI.
Responsibilities
- Design, develop, and maintain Azure Synapse data models for reporting and analytics.
- Develop ETL solutions using Azure Synapse Analytics Pipelines and dedicated SQL pools to extract, transform, and aggregate data from Salesforce objects.
- Analyze source systems and design ETL data loads.
- Create and configure Azure Synapse Analytics workspaces.
- Create Synapse pipelines using linked services, datasets, and pipelines to extract, transform, and load data from sources such as Salesforce.
- Monitor, troubleshoot, and maintain data architecture and pipelines.
- Collaborate with data engineers, analysts, and stakeholders to gather requirements and design visualizations.
- Provide training on self-service BI tools.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
