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).