What are the responsibilities and job description for the Azure Data Engineer position at Jobot?
This Jobot Job is hosted by: Jasmine Robinson
Are you a fit? Easy Apply now by clicking the "Quick Apply" button and sending us your resume.
Salary: $125,000 - $150,000 per year
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
Databricks/Spark
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.
Interested in hearing more? Easy Apply now by clicking the "Quick Apply" button.
Benefits:
401K, Employee Events, Employee Referral Program, Flexible Schedules, Free Food and Coffee, Game Rooms, Life Insurance, Maternity/Paternity Paid Leave, Medical, Dental and Vision, On Site Cafeteria, Paid Holidays, Paid sick days, Parking , Performance bonus, Professional Development, Retirement / Pension Plans, Vacation/paid time off, Work From Home
About the Company:
Jobot
Company Size:
500 to 999 employees
Industry:
Energy and Utilities
Founded:
2018
Website:
https://jobot.com/
Salary : $125,000 - $150,000