Sr. Data Analyst Job at Jobs via Dice in Eden Prairie

Overview

Join to apply for the Sr. Data Analyst role at Jobs via Dice

Location: Eden Prairie, Minnesota

Job type: Contract to Perm

Salary: $49 - 59 per hour

Work hours: 8am to 5pm

Education: Bachelors

Responsibilities

• Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced
• Efficiently communicate with ETL architect while understanding the requirements and business process knowledge in order to transform the data in a way that meets end users’ needs
• Assist in the overall architecture of the ETL Design, and proactively provide inputs in designing, implementing, and automating the ETL flows
• Investigate and mine data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
• Develop ETL pipelines and data flows in and out of the data warehouse using Azure Data Factory and Snowflake toolsets
• Develop idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines
• Work with Snowflake Virtual Warehouses and automate data pipelines using Snowpipe for ETL problems
• Capture changes in data dimensions and maintain versions using Stream sets in Snowflake and schedule them with Tasks
• Optimize every step of the data movement for performance, including when data is in transit and at rest
• Build a highly efficient orchestrator to schedule jobs, execute workflows, perform data quality checks, and coordinate task dependencies
• Test ETL system code, data design, pipelines, and data flows; perform root cause analysis and resolve production issues; conduct routine tests on databases and data flows
• Document implementations, test cases, and deployment documents needed for CI/CD

Required skills

• 5+ years of Data engineering experience with a focus on Data Warehousing
• 2+ years of experience creating pipelines in Azure Data Factory (ADF)
• 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL

Experience

• 5+ years of Data engineering experience with a focus on Data Warehousing
• 2+ years of experience creating pipelines in Azure Data Factory (ADF)
• 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools
• 5+ years of experience with Relational Databases, such as Oracle, Snowflake, SQL Server, etc.
• 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL
• 2+ years of experience with GitHub, SVN, or similar source control systems
• 2+ years of experience processing structured and un-structured data
• Experience with HL7 and FHIR standards and processing files in these formats
• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements
• Excellent problem-solving and analytical 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 a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, or Business

Team Structure

1 Data Manager
1 Data Modeller
1 Data Engineering Lead
4 Data Engineers

Qualifications

5+ years of Data engineering experience with a focus on Data Warehousing; 2+ years of experience creating pipelines in Azure Data Factory (ADF); 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL

Equal Opportunity

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact.

Pay offered to a successful candidate will be based on several factors including the candidate’s education, work experience, work location, specific job duties, certifications, etc. Randstad Digital offers a comprehensive benefits package, including medical, prescription, dental, vision, AD&D, life insurance, short-term disability, and a 401K plan (all benefits based on eligibility).

This posting is open for thirty (30) days.

Job metadata

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology
• Industries: Software Development