ETL Developer/Data Analyst

Lansing, MI, US • Posted 3 hours ago • Updated 3 hours ago
Contract W2
Contract Independent
12 Months
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • PROGRAMMER ANALYST
  • DATA ANALYST
  • ETL DEVELOPER
  • MICROSOFT AZURE
  • AZURE DEVOPS
  • GIT
  • CI/CD
  • AZURE SQL MANAGED INSTANCE
  • T-SQL
  • SQL
  • DATA INTEGRATION
  • DATA MIGRATION
  • CLOUD MIGRATION
  • AGILE METHODOLOGY
  • SPRINT PLANNING
  • STAND-UP MEETINGS
  • ITERATIVE DEVELOPMENT

Summary

Job Opportunity in Lansing, MI

Join our dynamic team in Lansing, MI, a vibrant city known for its rich history, cultural diversity, and growing tech industry. 

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

Key Responsibilities

  • Design, develop, and maintain scalable data pipelines using Microsoft Azure services.
  • Conduct data profiling, data cleansing, data validation, and resolve data quality issues during large-scale migration projects.
  • Oversee the identification and resolution of data irregularities by conducting root-cause analyses and implementing approved solutions.
  • Engage with customers and business partners to gather data-related requirements, ensuring alignment with ORS objectives.
  • Demonstrate strong SQL skills, particularly with Azure SQL Managed Instance, to manipulate, query, and transform data effectively.
  • Design complex data integration workflows that support ORS's data needs.
  • Perform data migration activities, including data mapping, transformation, validation, and migrating from on-prem data solutions to cloud databases.
  • Build and optimize ETL/ELT workflows using Azure Data Factory (ADF).
  • Embrace Agile software methodology, participating actively in Agile development practices, including sprint planning, stand-up meetings, and iterative development.
  • Stay informed about industry best practices and standards, advocating for and implementing data-driven solutions that maximize efficiency and quality.
  • Ability to think abstractly and break down complex data issues and solutions into simplified, actionable tasks.
  • Provide guidance and mentorship to first-time developers in data profiling and source-to-target mapping exercises.
  • Display familiarity with key data management concepts, including Master Data Management, Data Quality Management, Metadata Management, Data Security, Information Lifecycle Management, and Data Governance.
  • Effectively influence, negotiate, and lead delivery teams to recognize the critical role of data in all projects and initiatives.
  • Assess complex situations, set priorities, and implement action plans, ensuring a strong focus on delivering complete, provable, and high-quality outcomes.
  • Demonstrate strong written and verbal communication skills to professionally engage with management, staff, and customers. Display sound judgment and reasoning skills.

Qualifications

  • 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.

Interview Process

Interviews will be conducted in-person in Lansing, MI. No remote interviews will be permitted, this is non-negotiable.

Assignment Duration

1-year with the intent to extend based on business needs.

Hybrid Work Schedule

There is no remote-only option. In-office for 2 days per week is required (Tuesday/Wednesday).

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: 91138017
  • Position Id: 26-01370
  • Posted 3 hours ago

Company Info

About OP Consulting Group LLC

OP Consulting Group was formed by an IT Consultant who was frustrated with the current practices in the staffing industry. With a determination to bring change in the staffing practices, we came up with some bold business practices. We also offer complimenting services of Training and Consulting.

We are not just a middleman but are your partner to help turn your goals into reality. We do not see a job opportunity as a single transaction but the beginning of a long-term relationship.

OP Consulting Group’s promises to you are:
• Upfront and transparent pay rate
• We keep low margins
• Frequent and proactive communication of submission status
• We only work with direct clients or prime vendors
• On-time payment

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