MD
Data Solution Analyst / Data Modeling Expert
Macpower Digital Assets Edge Private Limited
🇺🇸 United States
On-site
5 days ago
$65 / hour
- Tableau
- MicroStrategy
- Business Objects
- Data Modeling
- Snowflake
- Data Architecture
- SQL
- Oracle
- MySQL
- Informatica
- Talend
- Devops
5 days ago
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.
- 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.
- 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).
Data Solution Analyst / Data Modeling Expert · Macpower Digital Assets Edge Private Limited