Sr Data Analyst(ETL,Data Warehousing) Job at Dmv It Service, Minneapolis, MN

L2JYT2xZb3RXRHIrbnFzK1NuOW9WNU5QL1E9PQ==
  • Dmv It Service
  • Minneapolis, MN

Job Description

Job Title:  Sr Data Analyst(ETL,Data Warehousing)

Location:  Minneapolis, MN

Employment Type:  Contract

About Us

DMV IT Service LLC, founded in 2020, is a trusted IT consulting firm specializing in IT infrastructure optimization, cybersecurity, networking, and staffing solutions. We partner with clients to achieve technology goals through expert guidance, workforce support, and innovative solutions. With a client-focused approach, we also provide online training and job placements, ensuring long-term IT success.

Job Purpose

The Senior Data Analyst is responsible for designing, building, and maintaining efficient ETL pipelines, transforming data for analytics, and ensuring the integrity and reliability of data flows. This role requires close collaboration with ETL architects, data engineers, and business stakeholders to analyze requirements, implement solutions, and troubleshoot production issues.

Key Responsibilities

  • Develop and maintain strong working relationships with other departments and technical teams to coordinate data initiatives.
  • Communicate effectively with ETL architects to understand requirements and business processes for data transformation.
  • Assist in ETL design and architecture, providing input on implementing and automating ETL workflows.
  • Investigate and analyze data to identify issues in ETL pipelines, notify end-users, and propose solutions.
  • Build and manage ETL pipelines and data flows using Azure Data Factory (ADF) and Snowflake .
  • Design idempotent ETL processes to allow interrupted or failed workflows to be safely rerun without errors.
  • Work with Snowflake Virtual Warehouses and automate data ingestion using Snowpipe .
  • Manage data versioning and capture changes using tools like StreamSets and schedule using Snowflake Tasks.
  • Optimize data movement and storage for performance improvements and accelerated response times.
  • Build orchestration frameworks to schedule jobs, manage dependencies, perform data quality checks, and execute workflows.
  • Test ETL pipelines, data flows, and system code; perform root cause analysis on production issues.
  • Document implementations, test cases, and deployment processes for CI/CD workflows.

Required Skills & Experience

  • 5+ years of data engineering experience , with a strong focus on data warehousing .
  • 2+ years of experience building pipelines in Azure Data Factory (ADF) .
  • 5+ years developing ETL using Informatica PowerCenter, SSIS, ADF , or similar tools.
  • 5+ years working with relational databases such as Oracle, Snowflake, or SQL Server.
  • 3+ years creating stored procedures using Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL.
  • 2+ years experience with source control systems such as GitHub or SVN.
  • 2+ years processing structured and unstructured data , including HL7 and FHIR formats.
  • 3+ years analyzing project requirements and creating detailed ETL specifications.
  • Strong analytical and problem-solving skills with the ability to troubleshoot and optimize data pipelines.
  • Ability to adapt to evolving technologies and changing business requirements.
  • Bachelor’s or Advanced Degree in Information Technology, Computer Science, Analytics, Mathematics, Statistics, or related field .

Preferred Skills & Attributes

  • 2+ years of experience with batch or PowerShell scripting .
  • 2+ years of Python scripting experience.
  • 3+ years of data modeling experience in a data warehouse environment.
  • Experience with Informatica Intelligent Cloud Services (Data Integration) .
  • Designing and building APIs in Snowflake and ADF (REST, RPC).
  • Experience with Healthcare/Medicaid/Medicare applications .
  • Azure certifications related to data engineering or analytics .

Job Tags

Remote job, Full time, Contract work,

Similar Jobs

Agiliti

Medical Equipment Service and Delivery Driver Job at Agiliti

 ...Wednesday - Saturday, 12:00pm - 10:30pm. $20/hr + $0.50 shift differential + full benefits. The Medical Equipment Service and Delivery Driver is responsible for driving to and from healthcare locations to complete delivery and equipment management tasks for a district... 

criteo

Senior Corporate Counsel Job at criteo

Senior Corporate CounselNew York, NYAbout CRITEOCriteo (CRTO), the leader in commerce marketing, is building the highest performing and...  ...collaboration.100% premium coverage of Healthcare Plan. When apples arent enoughCompetitive compensation. Be fancyCareer... 

UpLevel Sourcing

Director of Risk Managment Job at UpLevel Sourcing

 ...Job Description Job Description Director of Risk Management Overview We seek an experienced and proactive Director of Risk Management to lead patient safety, regulatory compliance, and risk reduction strategies for a 350-bed acute care hospital in Las Vegas,... 

EVEREST PARTS INC

In Home Appliance Technician Job at EVEREST PARTS INC

 ...* Job description Are you a skilled appliance technician looking to grow with a dynamic company?...  ...exceptional customer service and quality repairs. As a team member at Eve Services ,...  ...Top pay Company Vehicle (Take Home) Company Credit Card Opportunities... 

System One Services

Certified Pipe Welder Job at System One Services

 ...Job Description Job Description We are seeking a highly skilled and certified Pipe Welder to join our team. The ideal candidate will be responsible for welding and repairing pipes, tubes, and fittings for high-pressure applications in accordance with industry standards...