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 to transform 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.
- Transform raw data into meaningful insights. This is accomplished through interactive and user-friendly dashboards and reports.
- Interprets and executes data project requests. Presents report data in Power BI in a meaningful way, accessible and clear for individuals at all levels of understanding.
- 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.
Other
- 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
- Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
- Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences.
- Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines.
