Back to Jobs
Recently postedTechnology

Data Analyst/ETL Developer

IO DatasphereLansing, MI🇺🇸United States

Quick overview

Work modeHybrid
LocationLansing, MI, United States
Stakeholder ManagementSQLT-SQLGitETLAzureAgileProject ManagementCI/CDAzure DevOpsAzure Data Factory

Job description

IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.

Our client is looking for a Data Analyst/ETL Developer to 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 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.

Tasks:

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

Knowledge, Skills and Abilities Required:

  • Clear and concise written and verbal communication is crucial to success and productivity in this role.
  • 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.

NOTE: Local candidates preferred. Non-Local candidates must be willing to relocate within 70-miles of Lansing, MI prior to starting this position at their own expense. Hybrid Schedule: Mandatory Tuesday/Wednesday is required onsite.

Location: Lansing, MI

Contract: 1+ years

Skills Required:

  • 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
  • Proficiency in data integration and migration
  • Bachelor's Degree in a related field.

Skills Desired – A plus to have:

  • Cloud migration experience

Rate depends on experience

Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time.

Companies submitting candidates should only submit direct W2 employees for this position.

Please submit your resume by using the "URL" below

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs