RIT Solutions, Inc. · 2 months ago
Sr Data Analyst
Minneapolis, MN
Full-time
Hybrid
Senior Level
5+ years expRIT Solutions, Inc. is seeking a Senior Data Analyst to join their team. The role involves developing and managing ETL pipelines, collaborating with various departments, and ensuring data quality and architecture within the data warehouse.
Staffing & Recruiting
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's geared towards the needs of end users
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
Developing ETL pipelines and data flows in and out of the data warehouse using a combination of Azure Data Factory and Snowflake toolsets
Developing idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines
Ability to work in Snowflake Virtual Warehouses as needed in Snowflake and automate data pipelines using Snowpipe for tedious ETL problems
Capturing changes in data dimensions and maintaining versions of them using Stream sets in snowflake and scheduling them using Tasks
Optimize every step of the data movement not only limited to source and during travel but also when it's at rest in the database for accelerated responses
Must have the ability to build a highly efficient orchestrator that can schedule jobs, execute workflows, perform Data quality checks, and coordinate dependencies among tasks
Responsible for testing of ETL system code, data design, and pipelines and data flows. Root cause analysis on all processes and resolving production issues are also a part of the process and routine tests on databases and data flow and pipeline testing
Responsible for documenting the implementations, and test cases as well as responsible for building deployment documents needed for CI/CD
Qualification
Required
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
Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business
Preferred
2+ years of batch or PowerShell scripting
2+ years of experience with Python scripting
3+ years of data modeling experience in a data warehouse environment
Experience or familiarity with Informatica Intelligent Cloud Services (specifically Data Integration)
Experience designing and building APIs in Snowflake and ADF (e.g. REST, RPC)
Experience with State Medicaid / Medicare / Healthcare applications
Azure certifications related to data engineering or data analytics
Company
RIT Solutions, Inc.
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection).
201-500 employees
H1B Sponsorship
RIT Solutions, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (2)
Funding
Current Stage
Growth StageCompany data provided by crunchbase