Azure Data Engineer

Great collaborative company that is focused on utilizing and investing in the latest and greatest technology!

Easy Apply Now

A bit about us:

We focus on simplifying business transformation. We apply thought leadership and innovation to bring our customer’s digital agenda to reality. We partner with customers in their journey from vision to adoption, and across the plethora of technology options available today.

Why join us?

We offer a flexible work schedule, collaborative environment, and ability to work with the latest and greatest technology!

Job Details

We are seeking an experienced Senior Data Engineer who will work with clients and members of the consulting team on the architecture, design, and development of highly scalable data integration and data engineering processes. The Senior Consultant must have a strong understanding and experience with data & analytics solution architecture, including data warehousing, data lakes, ETL/ELT workload patterns, and related BI & analytics systems.

Additional responsibilities of this role will include the following:

Deliver consulting projects/work on-time, on-budget, and in a way that accomplishes client goals
Develop and implement technical best practices for data ingestion, data quality, data cleansing, and other data integration/ETL/Engineering-related activities
Understand and experience maintaining a multi-terabyte enterprise data warehouse with accompanying incremental data pipelines
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and modern cloud technologies.
Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments
Resolve source data issues and refine transformation rules
Analyze source system data to assess transformation logic and data quality through data profiling
Leverage data quality processes to assist with data cleansing requirements
Work with technical and business representatives to determine strategies for handling data anomalies that are identified
Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes
Develop, test, integrate, and deploy data pipelines using a variety of tools and external programming/scripting languages as necessary
Provide technical documentation and other artifacts for data pipelines, ingestion, integration or other data solutions
Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work
Apply creative thinking to identify possible reporting solution alternatives
Other duties assigned as needed
Requirements and Qualifications

3+ years hands-on experience with one or more of these data integration/ETL tools:
Azure Data Factory
Experience building on-prem data warehousing solutions
Experience with designing and developing ETL's, Data Marts, Star Schema's
Experience with building data warehousing solutions in Azure
Moving data from on-prem to cloud
Designing a data warehouse solution using Synapse or Azure SQL DB
Experience building pipelines using Synapse or Azure Data Factory to ingest data from various sources
Understanding of integration run times available in Azure
Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
Knowledge of scripting languages like Python, Scala.
Microsoft Azure Cloud platform certifications (nice to have)
Must be able to travel to client locations based on project needs

This position is contract-to-hire. You will be eligible for full-time benefits during the contract period.
Easy Apply Now
Easy Apply Now
Job Details
Managed by Jobot Pro
Dallas, TX
Job Type
$125,000 - $150,000