About the position
We are seeking a skilled and experienced Senior Data Design Analyst to join our team. The ideal candidate will play a key role in designing and optimizing data models for our data warehouse, ensuring data integrity, scalability, and performance. You will work closely with cross-functional teams, including data engineers, business analysts, and architects, to develop efficient data models that meet business and technical requirements.
Responsibilities
• Design, implement, and optimize data models for the data warehouse, ensuring alignment with business requirements.
• Work extensively with IBM IDA (InfoSphere Data Architect) to create logical and physical data models.
• Ensure that the data models are scalable, performant, and aligned with the organization's data strategy.
• Collaborate with data engineers to implement and maintain data models in Azure and Databricks environments.
• Translate business requirements into conceptual, logical, and physical data models, ensuring data quality and consistency across systems.
• Participate in data architecture and design discussions to ensure data modeling best practices are followed.
• Develop and maintain documentation of data models, data flow diagrams, and database design specifications.
• Work with stakeholders to ensure the data models support analytics, reporting, and data integration needs.
• Perform impact analysis of changes to existing models and collaborate with teams to assess the effects on downstream systems.
• Continuously improve and optimize data models to enhance performance and data accessibility.
Requirements
• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Proven experience as a Data Modeler working in data warehouse environments.
• Strong expertise with IBM IDA (InfoSphere Data Architect) or similar data modeling tools.
• Solid understanding of Azure and Databricks architecture, and experience working in cloud-based data environments.
• Proficiency in relational and dimensional data modeling techniques, including star and snowflake schemas.
• Hands-on experience with SQL and database design, with knowledge of data lakes, data warehouses, and ETL processes.
• Strong analytical and problem-solving skills, with attention to detail.
• Ability to communicate complex technical concepts to both technical and non-technical stakeholders.
• Familiarity with data governance, metadata management, and data quality practices.
Nice-to-haves
• Experience with Azure Synapse, Azure Data Factory, and Databricks Delta Lake.
• Knowledge of big data technologies and principles of data lakehouse architectures.
• Experience in agile methodologies and working in a fast-paced, collaborative environment.
Benefits
• Competitive salary range between $142,000.00 and $196,000.00.
• Annual discretionary incentive award.
• Comprehensive benefits portfolio.
Apply Now
Apply Now