IS Business Intelligence Data Architect: Azure Data Bricks

MedStar Health
MD, US
$111.8K-$201.4K a year
Full-time

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 Duties and Responsibilities

Contributes to the achievement of established department goals and objectives and adheres to department policies, procedures, quality standards, and safety standards.

Complies with governmental and accreditation regulations.

  • Maintains a thorough knowledge and understanding of database technologies, data integration, and BI tools.
  • Creates and maintains accurate design documentation for new projects and existing reporting artifacts and maintains a repository of data architecture and design artifacts and procedures.

Maintains accurate documentation in the EDW metadata repository.

  • Assists in the operations and maintenance of the EDW data pipelines, schedules data pipeline execution, monitors results, and remediates data pipeline errors.
  • Leads multiple design / development projects with multiple stakeholder groups, delivering cohesive data solutions that meet business, technical, and data governance requirements using the EDW and MedStar Health enterprise reporting solutions.
  • Establishes architectural guidelines for the data and analytics environment in areas including scalability, security, performance, data recovery, reliability, and usability, and applies those guidelines to the design and implementation of EDW, reporting, and analytics projects.
  • Collaborates with MedStar Health's EDW vendor to manage data warehouse data pipelines and optimize the EDW platform
  • Leads development teams in the build and validation of those data marts, dashboards, and extracts, including performance of build and validation tasks.

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 $111,779 - $201,427

30+ days ago
Related jobs
Promoted
Booz Allen Hamilton
Annapolis, Maryland

As a Senior Data Architect, you will manage and analyze data using your strong analytical skills, experience with data management tools, and solid understanding of data governance principles. Draft data usage agreements and clean and schedule transfers of data from various sources to support busines...

Promoted
Oracle
Annapolis, Maryland

Oracle US offers a comprehensive benefits package which includes the following:Medical, dental, and vision insurance, including expert medical opinionShort term disability and long term disabilityLife insurance and AD&DSupplemental life insurance (Employee/Spouse/Child)Health care and dependent care...

NTT DATA Services
Bethesda, Maryland

NTT DATA is seeking a highly experienced and motivated Cloud Architect to oversee the architecture and implementation of all cloud support services for a federal scientific research agency. AWS Certified Solutions Architect - Professional, Microsoft Azure Solutions Architect Expert, Google Cloud Cer...

Data Computer Corporation of America (DCCA)
Columbia, Maryland

DCCA is a veteran-owned IT business specializing in providing innovative solutions to a variety of government agencies and commercial enterprises since 1982. REQUIRED) Understanding of FISMA, IS2P, NIST, and similar security requirements. REQUIRED) Develop and maintain a security architecture that a...

AgileEngine
Baltimore, Maryland

A minimum 7 years of design & implementation experience with distributed applications and systems; 3+ years of hands-on experience with architecting solutions on Cloud Platforms; Ability to design and document data architecture, governance and management processes; Ability to analyze and document da...

Retail Business Services
Hyattsville, Maryland

This will require solving some fundamental and highly challenging issues in terms of what data to capture and how to integrate the data between the business functions, and how to organize it for maximum leverage; what tools and technologies we should deploy; and how we define data governance. Lead E...

Breakthru Beverage Group
Linthicum Heights, Maryland

Perform, Design & Develop Enterprise SolutionsLead BBG’s entire Business Intelligence solution that enables our data architecture strategy, including data design, modeling, storage, performance metrics, visualization tools, metadata, data quality, and data governance objectives. This includes data m...

Perdue Farms
Salisbury, Maryland

Assists with managing, analyzing, and resolving data initiative issues with close direction of supervisor to best meet internal and customer requirements while adhering to published data standards. Assists in design and implementation of data strategy, policies, controls, and programs to ensure the ...

Booz Allen Hamilton
Bethesda, Maryland

We’re looking for a data architecture Senior Manager like you to solve complex challenges and deliver leading-edge solutions for cloud-based enterprise data architectures that support business operations, advanced analytics, business intelligence and data science initiatives within the federal gover...

Data Computer Corporation of America (DCCA)
Ellicott City, Maryland

The Defense & Intelligence Division BD Director – Defense (USAF/USSF Focus) partners with the DCCA Chief Growth Officer (CGO), the Defense & Intelligence Division’s Sr. DCCA is a veteran-owned IT business specializing in providing innovative solutions to a variety of government agencies and commerci...