Data Solution Analyst / Data Modeling Expert

Job Summary: As a Data Solution Analyst, you will be responsible for translating functional data and analytical requirements into scalable solutions that can be utilized by business and technology teams. Leveraging a range of technologies including Paxata, Tableau, MicroStrategy, Business Objects, and R you will craft innovative data models, analyses, and visualizations that enable actionable insights. This position also offers the opportunity to guide others in implementing self-service reporting and analytics techniques.
We are seeking a skilled Data Modeling Expert with extensive experience in traditional data modeling (e.g., 3NF, Star/Snowflake, Hybrid), data architecture, and data management best practices.
Key Responsibilities:

• Design and implement logical and physical data models for analytical data stores (e.g., Data Warehouses, Data Lakes).
• Collaborate with business analysts, data engineers, and other stakeholders to understand data requirements and create effective data structures.
• Conduct data profiling, quality assessments, and cleansing activities to ensure high data integrity.
• Develop and maintain Source-to-Target mapping documents, detailing complex data transformations and integrations.
• Ensure compliance with data governance and security policies, while adhering to best practices.
• Provide mentorship and technical guidance to junior team members, including data modelers and data engineers.

Required Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Minimum of 5 years of experience in data modeling, covering the entire development lifecycle (requirements to deployment).
• At least 2 years of experience in designing data structures for Data Warehouses, Data Lakes, or Analytical systems.
• Strong proficiency in data modeling tools, such as ER/Studio, Erwin, or PowerDesigner.
• Proven experience in data analysis and profiling, with at least 5 years in the field.
• Proficiency in SQL and experience with database management systems (e.g., Oracle, SQL Server, MySQL).
• Exceptional problem-solving skills and keen attention to detail.
• Strong ability to resolve issues by forming and leading cross-functional teams.
• Excellent communication and collaboration skills, with proven success in facilitation and consensus-building.

Preferred Qualifications:

• Experience with data integration tools such as Informatica or Talend.
• Knowledge of DevOps and DataOps practices.
• Familiarity with data governance frameworks and methodologies.
• Relevant certifications in data management or modeling (e.g., CDMP, DAMA).