Our client is seeking a dedicated and experienced Senior Data Analyst to join their dynamic team. This role is remote and offers a 12-month contract-to-hire opportunity. Successful candidates will be required to complete a background check and drug screen upon offer acceptance.
 

Key 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 to understand requirements and business processes

• Assist in the overall architecture of the ETL Design, providing proactive 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

• Optimize every step of the data movement for accelerated responses

• 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, pipelines, and data flows

• Document implementations, test cases, and build deployment documents needed for CI/CD
   

Required Skills and 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

• 3+ years analyzing project requirements and developing detailed specifications for ETL requirements

• Bachelor's or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business
   

Preferred Skills and Experience:

• 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

• Experience designing and building APIs in Snowflake and ADF

• Experience with State Medicaid / Medicare / Healthcare applications

• Azure certifications related to data engineering or data analytics
   

As a member of our client's team, the Senior Data Analyst will support the Alabama EDS by developing and maintaining workflows, identifying and resolving data quality issues, and optimizing processes to improve performance. The ideal candidate will have healthcare (Medicaid) and Microsoft Azure-based experience with Snowflake and Azure Data Factory.


Horizontal facilitates valuable and productive conversations between you and potential employers. We can assist you in growing your career by partnering you with employers that offer challenging assignments.  For those that join the team, we offer competitive compensation and benefits including medical, dental, vision, and retirement. Check out all we have to offer and how you can become part of the Horizontal Talent Team. The pay range for this role is $31 - $64 per hour. This is not a guarantee of compensation, as final offer amount may vary based on factors including but not limited to experience and geographic location.