Senior Azure Data Engineer – ADF, Microsoft Fabric & SQL and ETL -Hybrid@Michigan( Local to MI)

Hybrid in Lansing, MI, US • Posted 35 minutes ago • Updated 34 minutes ago
Contract Independent
Contract W2
6 Months
No Travel Required
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Extract, Transform, Load
  • Data Quality
  • Data Management
  • Data Migration
  • Microsoft Azure
  • Migration
  • SQL
  • SQL Azure
  • DevOps

Summary

Title :  Senior Azure Data Engineer – ADF, Microsoft Fabric & SQL and ETL

Interview Process : Interviews will be conducted in-person in Lansing, MI.

Location: 525 West Allegan Street, Lansing, MI – 48933- Hybrid

Candidates must be willing to relocate within 70-miles of Lansing, MI within the 1st week of starting this position.

The State will not provide any relocation assistance with relocating, all costs incurred are the sole responsibility of the candidate.

 

Top Skills & Years of Experience:

-6+ years of experience with Microsoft Azure, Azure DevOps, Git, CI/CD

-6+ years of experience with Azure SQL Managed Instance, Strong SQL and T-SQL skills

-6+ years of experience with Azure Data Factory (ADF), Microsoft Fabric

-Bachelor's Degree in a related field.

-Clear and concise written and verbal communication is crucial to success and productivity in this role

 

Job Description

Data Analyst / ETL Developer (Contractor)-PA5

Position: Data Analyst / ETL Developer Location: State of Michigan, Department of Technology Management and Budget, Office of Retirement Services (ORS).

Position Description:

As a Data Analyst / ETL Developer within the Office of Retirement Services (ORS), you will play a vital role in managing and optimizing the data infrastructure, ensuring data quality, and facilitating effective data migration efforts. You will work as a contractor, collaborating closely with internal stakeholders and technical teams to support ORS's data-related initiatives, especially in the context of our ongoing modernization effort, using Agile methodologies, to update our current 20-year-old software package, to a modernized new product for the future.

Key Responsibilities:

  1. Expertise in Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
  2. Strong experience with data profiling, data cleansing, data validation, and resolving data quality issues during large-scale migration projects.
  3. Root-Cause Analysis: Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions.
  4. Requirements Gathering: Engage with customers and business partners to gather data-related requirements, ensuring alignment with ORS objectives.
  5. SQL Expertise: Demonstrate strong SQL skills, particularly with Azure SQL Managed Instance, to manipulate, query, and transform data effectively.
  6. Data Integration Workflow Design: Leverage multiple years of experience to design complex data integration workflows that support ORS's data needs.
  7. Data Migration Leadership: Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases.
  8. Modernization Effort: Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
  9. Agile Methodology: Embrace Agile software methodology, participating actively in Agile development practices, including sprint planning, stand-up meetings, and iterative development.
  10. Industry Best Practices: Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality.
  11. Problem-Solving Skills: Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks.
  12. Mentorship: Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises.
  13. Data Management Knowledge: Display familiarity with key data management concepts, including Master Data Management, Data Quality Management, Metadata Management, Data Security, Information Lifecycle Management, and Data Governance.
  14. Stakeholder Engagement: Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives.
  15. Customer Expectation Management: Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes.
  16. Strong Communication: Demonstrate strong written and verbal communication skills to professionally engage with management, staff, and customers. Display sound judgment and reasoning skills.

Qualifications (This is a senior position and requires 6+ years of experience):

  • Bachelor's degree in a related field (or equivalent work experience).
  • Proven experience as a Data Analyst or ETL Developer.
  • Proven skills in Microsoft Azure, Azure Data Factory, and Microsoft Fabric.
  • Expertise in SQL, T-SQL, especially with Azure SQL Managed Instance.
  • Expertise in Azure DevOps, Git, CI/CD
  • Proficiency in data integration and migration, with cloud migration experience as a plus.
  • Understanding of industry data management best practices and standards.
  • Strong problem-solving and analytical skills.
  • Ability to mentor and guide junior team members.
  • Knowledge of data management concepts, including MDM, Data Quality, Metadata Management, Data Security, ILM, and Data Governance.
  • Excellent stakeholder engagement, negotiation, and leadership skills.
  • Strong organizational skills with the ability to work independently and collaborate effectively within a team.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91162806
  • Position Id: 9148772
  • Posted 35 minutes ago

Company Info

About HPTech Inc.

HPTech Inc has grown to become a premier provider of IT consulting services for technology. With a specialized niche in transaction and data warehousing applications, HPTech Inc helps clients implement mission-critical, enterprise solutions, speed conversion from legacy environments, and optimize the benefits inherent in their systems. Our consulting solutions range from project strategy and planning, software assessment and selection, to implementation and integration, hosting and change management, support and maintenance translating to higher productivity, lower costs.

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.