Principal Data Analyst(PowerBI,Azure)

Codetech•Minneapolis, MN

5h•Remote

About The Position

The Principal Data Analyst will develop and deliver long-term data architecture goals and standards in collaboration with data users, clients, and other stakeholders. The role leads data architecture, data modeling, and data movement initiatives for a data warehouse supporting analytics for Medicaid, Medicare, and commercial healthcare data, including claims, provider, TPL, and member information. The position translates business needs into long-term solution data models and defines how logical designs map to physical databases and how data moves through successive stages. It evaluates existing data systems, works with development teams on conceptual data models and data flows, and oversees the mapping of data sources, movement, interfaces, and analytics to support data quality. It also ensures regulatory compliance, develops data model and metadata policies and procedures, and identifies policies or procedures that need to be changed or created. The role provides technical recommendations and works with ETL Architects, Business SMEs, and other stakeholders throughout solution and data architecture implementation. It develops scalable, high-performance data solutions, addresses systems integration and compatibility issues, and creates testing criteria to validate data architecture fidelity and performance. The position documents the data architecture and enterprise environment to maintain an accurate, scalable view of enterprise data. It also communicates with customers and project teams and escalates issues and risks appropriately. The posting also describes work supporting Optum’s CT EDW within the Enterprise Datawarehouse and Analytics group. The Data Modeler will work with large healthcare datasets, translate client business requirements into enterprise systems, applications, or process designs for complex health data solutions, and support CT EDW initiatives and broader EDW activities involving data usage and governance, information management, privacy and security, SOA, data analytics and visualization, and information modeling.

Requirements

Strong problem-solving, influencing, communication, and presentation skills; self-starter.
Expertise in data modeling, data strategy, and roadmaps for large and complex health entities and systems.
Experience implementing large-scale, end-to-end data management and analytics solutions for more than one large client.
Strong knowledge of regulatory security requirements concerning HIPPA, PHI, PII, and other healthcare data security standards.
Strong healthcare domain knowledge of Medicaid, Medicare, and commercial healthcare datasets.
Expertise in normalized OLTP, OLAP, MDM, and dimensional modeling techniques, including star schemas, slowly changing dimensions, role-playing dimensions, dimensional hierarchies, and data classification.
Expert-level SQL skills, including complex analytic queries, stored procedures, DDL, DML, and DCL.
Thorough knowledge of query optimization and ability to write ANSI-standard code and inspect code written by other developers.
Expertise in data quality, data profiling, data governance, data security, metadata management, MDM, data archival, and data migration strategies using appropriate tools.
At least 5 years of experience with Erwin Data Modeler.

Nice To Haves

Experience with Microsoft Azure cloud infrastructure and services, including Azure Data Lake Storage, Azure Data Factory, Purview, and Azure Maps.
Experience with Snowflake DBMS.
Experience with Power BI or Tableau.

Responsibilities

Develop long-term strategic goals for data architecture vision and standards with data users, clients, and stakeholders.
Lead data architecture, data modeling, and data movement initiatives for a healthcare analytics data warehouse.
Define how logical data designs translate into physical databases and how data flows through successive stages.
Analyze and translate business needs into long-term solution data models.
Evaluate existing data systems and work with development teams to create conceptual data models and data flows.
Ensure data strategies and architectures comply with regulatory requirements; identify policies and procedures that require changes or need to be created.
Oversee mapping of data sources, data movement, interfaces, and analytics to support data quality.
Create and maintain data model and metadata policies and procedures for functional design.
Provide technical recommendations and collaborate with ETL Architects, Business SMEs, and other stakeholders through architecture and implementation.
Recommend effective solutions for high-performance, scalable data marts, warehouses, data mining, and advanced analytics.
Address data-related systems integration, compatibility, and multiple-platform integration problems.
Develop and implement testing criteria to verify data architecture fidelity and performance.
Document data architecture and the enterprise environment to maintain an accurate view that supports a single version of the truth and future analytical needs.
Communicate with customers and project teams in a timely manner and escalate issues and risks appropriately.
Translate client business requirements into enterprise systems, applications, or process designs for complex health data solutions.
Support CT EDW initiatives and broader EDW work involving data usage and governance, information management, privacy and security, SOA, analytics and visualization, and information modeling.