Data Modeler
Data Modeler
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
The Data Modeler will serve as a senior technical resource supporting enterprise data warehouse modernization initiatives. This role involves designing developing and maintaining logical and physical data models creating centralized data frameworks and supporting advanced analytics and reporting needs. The Data Modeler will collaborate with business stakeholders analysts and development teams to ensure the delivery of optimized scalable and secure data solutions leveraging Microsoft Azure technologies such as Databricks Delta Lake and Synapse.
Responsibilities:
- Design develop and implement data models and data lake architectures for enterprise-scale data warehouse modernization.
- Conduct data profiling analysis and validation to ensure accuracy consistency and quality of models.
- Create and maintain logical and physical data models metadata repositories and data dictionaries.
- Translate business requirements into optimized database solutions data flows and information domain models.
- Develop SQL Server database solutions including stored procedures complex queries and ELT processes.
- Support and enhance existing and new data warehouse initiatives ensuring adherence to best practices and compliance standards.
- Collaborate with business analysts developers DBAs and program area stakeholders to align solutions with organizational objectives.
- Evaluate existing systems and recommend improvements to enhance performance scalability and data integrity.
- Manage assignments track progress and provide project updates and documentation through established project management tools.
- Participate in requirements gathering testing quality reviews and knowledge transfer activities.
- Provide presentations training sessions and technical guidance to teams and stakeholders.
- Ensure data security compliance and adherence to federal and state standards for data governance.
Requirements:
- Advanced expertise in data analysis data profiling and database design.
- Hands-on experience with logical and physical data modeling tools (e.g. ErWin or equivalent).
- Strong proficiency in SQL Server T-SQL SSIS ELT processes scripts and stored procedures.
- Proven experience managing metadata data dictionaries and technical documentation.
- Working knowledge of Microsoft Azure cloud services including Databricks Delta Lake Synapse and Python.
- Familiarity with relational databases star schema facts and dimensions.
- Experience with Agile/Scrum methodologies and tools such as Azure DevOps.
- Demonstrated ability to audit databases maintain data quality and implement secure systems.
- Excellent communication skills with the ability to present complex data concepts to diverse audiences.
- Strong organizational skills and ability to manage multiple priorities with minimal supervision.
- Bachelors degree in Computer Science Information Systems or a related field; advanced study preferred.
- 10 years of relevant experience in data modeling and data architecture.
Preferred Experience:
- Experience working in the public health or healthcare industry with large and diverse health datasets.
- Familiarity with government or regulated industry data governance standards and compliance requirements.
Employment Type
Full-time
