ETL Developer
- Req #: 8697
- Address: 2100 Sherman Ave
- City, State: Norwood, OH
- Zip: 45212
- Type: Full time
- Shift: Day
Job Description
The primary focus of this position will be to work collaboratively with our Data & Analytics teams for the day-to-day maintenance and support of one or more of the Epic Cogito related systems, which could include one or more of the Clarity, Caboodle, or other SQL databases, Reporting, SSIS Packages, SSAS Cubes, and other related database systems. A percentage of the time may be devoted to authoring BI reports as needed.
Responsibilities
- Design, develop, and maintain ETL processes to support data integration and transformation requirements.
- Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
- Implement data mappings, transformations, and data quality rules to ensure accurate and reliable data processing.
- Perform data profiling and analysis to identify data quality issues and improvement opportunities.
- Develop and execute efficient and optimized SQL queries for data extraction and transformation.
- Optimize and enhance existing ETL workflows to improve performance, scalability, and data quality.
- Collaborate with database administrators and data architect to ensure seamless integration with data sources and targets.
- Document ETL processes, data mappings, and configurations for future reference and troubleshooting.
- Conduct thorough testing and debugging of ETL processes to ensure accurate and reliable data processing.
- Stay updated with emerging ETL technologies, industry best practices, and data integration trends.
- Strong SQL programming skills and strong RDBMS knowledge.
- Collaborate with cross-functional teams to ensure successful integration of ETL solutions with other systems and applications.
- Utilize testing tools and techniques to ensure the quality and reliability of ETL processes.
- Support troubleshooting eff orts and provide timely resolution for production issues related to ETL processes.
Qualifications
Education: Bachelors degree, or equivalent combination education/paid job experience required
Years of Experience: 3+
Required Knowledge, Skills & Abilities:
- Epic data model certification in Clarity and Caboodle required.
- Minimum of 3 years of experience working with Microsoft SQL Server databases, preferably in a healthcare or related field required
- Advanced SQL knowledge and experience working with relational databases, query authoring (T-SQL) as well as working familiarity with a variety of database
- Minimum 1 year of ETL experience with Microsoft SSIS
- Experience with healthcare reporting regulations, certifications and compliance
- Experience with SFTP application for automated secure transfer of extract file
- Experience with SQL Server Administration and security
- Experience with SQL Server Agent Administration; jobs, schedules, Integrations Services Catalog, alerts & security
- Experience with dimensional (Star Schema) data modeling
- Experience with modern BI tools such as Power BI (preferred), Tableau or SAP BusinessObject
- Experience with Microsoft suite of database related tools: Azure, Visual Studio, SSIS, SSAS, and SSRS
- Strong analytic skills related to working with unstructured datasets.
- Experience with or knowledge of Agile Development methodologie
- The candidate must be self-starting, have a strong attention to detail and accuracy, and have a demonstrated knowledge of data architecture/data modeling in a source and warehouse environment.
The primary focus of this position will be to work collaboratively with our Data & Analytics teams for the day-to-day maintenance and support of one or more of the Epic Cogito related systems, which could include one or more of the Clarity, Caboodle, or other SQL databases, Reporting, SSIS Packages, SSAS Cubes, and other related database systems. A percentage of the time may be devoted to authoring BI reports as needed.
Responsibilities
- Design, develop, and maintain ETL processes to support data integration and transformation requirements.
- Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
- Implement data mappings, transformations, and data quality rules to ensure accurate and reliable data processing.
- Perform data profiling and analysis to identify data quality issues and improvement opportunities.
- Develop and execute efficient and optimized SQL queries for data extraction and transformation.
- Optimize and enhance existing ETL workflows to improve performance, scalability, and data quality.
- Collaborate with database administrators and data architect to ensure seamless integration with data sources and targets.
- Document ETL processes, data mappings, and configurations for future reference and troubleshooting.
- Conduct thorough testing and debugging of ETL processes to ensure accurate and reliable data processing.
- Stay updated with emerging ETL technologies, industry best practices, and data integration trends.
- Strong SQL programming skills and strong RDBMS knowledge.
- Collaborate with cross-functional teams to ensure successful integration of ETL solutions with other systems and applications.
- Utilize testing tools and techniques to ensure the quality and reliability of ETL processes.
- Support troubleshooting eff orts and provide timely resolution for production issues related to ETL processes.
Qualifications
Education: Bachelors degree, or equivalent combination education/paid job experience required
Years of Experience: 3+
Required Knowledge, Skills & Abilities:
- Epic data model certification in Clarity and Caboodle required.
- Minimum of 3 years of experience working with Microsoft SQL Server databases, preferably in a healthcare or related field required
- Advanced SQL knowledge and experience working with relational databases, query authoring (T-SQL) as well as working familiarity with a variety of database
- Minimum 1 year of ETL experience with Microsoft SSIS
- Experience with healthcare reporting regulations, certifications and compliance
- Experience with SFTP application for automated secure transfer of extract file
- Experience with SQL Server Administration and security
- Experience with SQL Server Agent Administration; jobs, schedules, Integrations Services Catalog, alerts & security
- Experience with dimensional (Star Schema) data modeling
- Experience with modern BI tools such as Power BI (preferred), Tableau or SAP BusinessObject
- Experience with Microsoft suite of database related tools: Azure, Visual Studio, SSIS, SSAS, and SSRS
- Strong analytic skills related to working with unstructured datasets.
- Experience with or knowledge of Agile Development methodologie
- The candidate must be self-starting, have a strong attention to detail and accuracy, and have a demonstrated knowledge of data architecture/data modeling in a source and warehouse environment.
