Job Description
Principal Data Modeler
Location: MN101 – 100% Telecommute
Work Hours: Monday – Friday | 9:00 AM – 5:00 PM
Project Summary:
seeking a hands-on Principal Data Analyst to support its Connecticut Enterprise Data Warehouse (CT EDW) within the Enterprise Datawarehouse and Analytics group. This role will work with large-scale healthcare data, translating business requirements into high-performing data models, and contributing to data strategy, governance, security, and analytics platforms supporting Medicaid, Medicare, and Commercial lines of business.
Ideal Candidate Background:
- Proven experience as a Senior or Principal Data Modeler in the healthcare industry, specifically with Medicaid.
- A strong strategic mindset for developing data roadmaps and architectural visions.
- Ability to work independently in a remote setup and lead complex data initiatives.
Key Responsibilities:
- Develop and deliver long-term strategic goals for data architecture and standards in partnership with data users and stakeholders.
- Lead initiatives for data modeling, data movement, and architecture enhancement to support a robust and scalable data warehouse.
- Build logical and physical data models and translate business requirements into technical solutions across the data lifecycle.
- Design and maintain data systems and data flows while ensuring regulatory compliance (HIPAA, PHI, PII).
- Oversee source-to-target mapping, metadata, and governance documentation to ensure data integrity and quality.
- Collaborate with ETL architects, SMEs, and business teams to design high-performance data marts and analytics platforms.
- Support data integration, data security, data quality, and metadata management strategies.
- Provide technical leadership throughout the implementation lifecycle and recommend innovative data solutions.
- Create testing criteria and documentation to maintain architectural fidelity and scalability.
- Drive best practices for enterprise-wide data modeling and architecture standards.
Required Skills & Experience:
- 5+ years of hands-on experience using Erwin Data Modeler.
- Strong Data Modeling and Data Architecture experience with large-scale healthcare data systems.
- Expertise in OLTP, OLAP, MDM, dimensional modeling (star schemas, SCDs, etc.).
- Proficiency in SQL including advanced queries, stored procedures, DDL, DML, DCL, and query optimization techniques.
- In-depth knowledge of Medicaid, Medicare, and Commercial healthcare data.
- Experience in Data Governance, Data Security, Data Profiling, Metadata Management, and MDM.
- Strong understanding of HIPAA, PHI, PII, and healthcare security requirements.
- Excellent problem-solving, communication, and stakeholder management skills.
Preferred Qualifications:
- Experience with Microsoft Azure services: Azure Data Lake Storage, Azure Data Factory, Purview, Azure Maps, etc.
- Familiarity with Snowflake DBMS.
- Experience with data visualization tools like Power BI or Tableau.
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status