> Markdown version of [/jobs/ext/1503934-sr-data-analyst-azure-data-factory](https://www.wearedevelopers.com/jobs/ext/1503934-sr-data-analyst-azure-data-factory). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr Data Analyst ( Azure Data Factory) - **Company:** Summer Street Capital Partners LLC - **Location:** Eden Prairie, MN, United States - **Experience:** Expert - **Salary:** $100,000.0 - $125,000.0 - **Contract:** Temporary to permanent - **Skills:** Data Analysis, Microsoft Azure, Clinical Data Repository, Information Engineering, Extract Transform Load (ETL), Data Systems, Data Warehousing, Relational Databases, Github, Revision Control Systems, Information Management, Information Model, Microsoft SQL Server, Oracle (Applications), Oracle SQL Developer, Windows PowerShell, Service-Oriented Architecture, SQL Stored Procedures, SQL Server Integration Services, Subversion, Transact-SQL, Scripting, Azure Data Factory, Informatica Powercenter, Fast Healthcare Interoperability Resources, Snowflake, Apache Spark, Usage Tracking, Information Technology, Data Analytics, Health Level Seven International, Api Design, Data Pipelines, Databricks - **Published:** July 30, 2026 - **Apply:** https://www.careerjet.com/jobad/usd4891cd116b51f0eb4768bfeb1563359 ## About the Role 12. What skills/attributes are required (please be detailed as to number of years of experience for each skill)? 8+ years of Data engineering experience with a focus on Data Warehousing 5+ years of experience creating working with Azure Data Factory (ADF) and Databricks 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. 5+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL 3+ years of experience with Python scripting. 3+ years of experience with Azure DevOps, 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 13. What skills/attributes are preferred (what will set a candidate apart)? 3+ years of batch or PowerShell scripting 3+ years of data modeling experience in a data warehouse environment Experience or familiarity with Spark and Azure Data Fabric. 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. 14. Does this position require a professional license or certification?, 16. What does the ideal candidate background look like (ex: healthcare specific background, etc.)? We want to be as specific as possible with our firms so they can find the type of candidate you're looking for. Data Engineer with Healthcare (Medicaid) and Microsoft Azure based experience with Snowflake and Azure Data Factory 17. Of the required skills listed, which would you consider the top 3? Please list your expectations regarding years of experience for each requirement. 8+ years of Data engineering experience with a focus on Data Warehousing 5+ years of experience creating working with Azure Data Factory (ADF) and Databricks 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. 5+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL 3+ years of experience with Python scripting. 3+ years of experience with Azure DevOps, 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 18. What experience will set candidates apart from one another? 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, 12. What skills/attributes are required (please be detailed as to number of years of experience for each skill)? 8+ years of Data engineering experience with a focus on Data Ware… ## Description Optum is currently seeking a hands-on Senior Data Engineer to support our CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Engineer will work with large healthcare datasets and will translate client's business requirements into enterprise systems, applications, or process designs for large complex health data solutions. The role will drive and support initiatives for the CT EDW as well as participate in the wider EDW groups areas of data usage and governance, information management, privacy and security, SOA, data analytics and visualization and information modeling., 20. What does the team structure look like how many members and what is the break-down of the team's skill sets (ex: 1 PM, 4 Developers, etc.)? 1 Data Manager 1 Data Modeller 1 Data Enigneering Lead 4 Data Engineers Business Analyst QA Testers DBA 21. What does the interview process look like? a. How many rounds? 3 b. Video vs. phone? Video c. How technical will the interviews be? Technical, Description : Overall Summary: The Senior Data Analyst is responsible for the operational integrity of IWCO Direct's reporting ecosystem and for leading the migration from lega… + 1 month ago ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)