MedImpact Healthcare Systems, Inc. is looking for extraordinary people to join their team to deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. This role is responsible for the development and administration of data pipelines, the data warehouse, and BI tools, transforming raw data into meaningful insights through interactive and user-friendly dashboards and reports.
Requirements
- Advanced SSIS development skills, including parameterization, and partition switching.
- Strong experience in building and maintaining CI/CD pipelines in Azure DevOps
- Advanced proficiency with ETL and ELT frameworks, SQL, and SQL Server Reporting Services (SSRS) for the generation and extraction of data for use in analytics and reporting.
- Proficient in creating complex DAX queries in Power BI Desktop & Report Builder.
- Strong knowledge of Power BI Report Builder tool.
- Strong knowledge of Power BI service.
- Ensure code quality with Test Driven Development/ unit testing.
Responsibilities
- Responsible for the development and administration of data pipelines, the data warehouse, and BI tools.
- Develops queries, functions, stored procedures, and views to support reporting and data extraction, utilizing standards and best practices to ensure data accuracy and security.
- Design, develop, and optimize complex SQL Server solutions, including stored procedures, SSIS packages, and views and other database objects.
- Develops best practice procedures for end users to facilitate the use of reporting tools and applications.
- Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products.
- Adopts new techniques and technologies.
- Assists with mentoring and training of less experienced IT staff members.
Other
- This position is not eligible for Sponsorship.
- This is an internal and external client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written).
- BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas
- Microsoft Azure Data Engineer Certification is highly desirable
- Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
