IS Business Intelligence Data Architect: Azure Data Bricks Job Listing at MedStar Medical Group in Columbia, MD (Job ID req33074)

Description

General Summary of Position
The IS Business Intelligence Data Architect assists in architectural oversight and development for MedStar Health's Enterprise Data Warehouse (EDW), data marts and data pipelines. Designs and implements database and BI Solutions that enable the business to derive valuable insights. Partners with stakeholders and subject matter experts to document requirements for data marts, dashboards, and data extracts; and translates those requirements into technical design specifications. Works with MedStar Health's EDW vendor to manage data warehouse data pipelines and optimize the EDW platform. Participates in a range of cross-functional activities related to data governance, standardization of data and reporting, and utilization of BI reports for all areas of the business.

**Primary Responsibilities:**
- Support and maintain the existing ADF and Databricks implementation.
- Lead the design and development of our Databricks-based analytics platform.
- Collaborate with cross-functional teams to ensure data integration and analytics requirements are met.
- Maintain and optimize existing data pipelines using ADF to pull and retrieve data from various sources.
- Optimize data pipelines and workflows for performance and scalability.
- Execute Databricks notebooks to transform and load data into the company Lakehouse.
- Ensure tight integration with Azure DevOps for continuous integration and deployment.
- Troubleshoot and resolve issues related to data pipelines and analytics workflows.

**Preferred Qualifications:**
- Certification in Databricks or related technologies.
- Proven experience with Azure Data Factory and Databricks.
- Proven experience as a Databricks Engineer or similar role.
- Experience with SQL and data warehousing solutions.
- Experience with Azure DevOps for CI/CD.
- Background in Healthcare IT and familiarity with healthcare data standards and regulations.
- Knowledge of machine learning and data science concepts.

Minimum Qualifications
Education

• Bachelor's degree in Computer Science or Related Field of Study required and
• Master's degree preferred

Experience

• 5-7 years Experience in data integration, database design, and development required and
• 3-4 years Experience in BI reporting and analysis, with advanced skills using BI tools such as Tableau or Power BI. required and
• 1-2 years Knowledge of and experience with statistical analysis and modeling required and
• Experience with data warehousing models, designing processes for complex data structures, and using best practices in data integration required

Knowledge, Skills, and Abilities

• Ability to write complex SQL queries.
• Ability to translate ambiguous concepts into tangible ideas and to present products such as design documents, reports and other deliverables to a broad audience.
• Demonstrated ability in the use of advanced analytical and technical problem-solving skills and experience conceptualizing ideas.
• Advanced knowledge and skill in the practical use of SQL, Python, and Tableau.
• Excellent interpersonal (verbal and written) communication skills.
• Demonstrated proficiency with Microsoft Office applications, including Word, Excel, Outlook, Visio, and PowerPoint.

This position has a hiring range of $122,948 - $212,513