ETL Developer/Data Analyst


OP Consulting Group LLC
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).
- 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

