Data Solution Analyst / Data Modeling Expert Job at Macpower Digital Assets Edge

Data Solution Analyst / Data Modeling Expert

Data Solution Analyst / Data Modeling Expert

1 day ago Be among the first 25 applicants

Macpower Digital Assets Edge formerly MDA Edge provided pay range

This range is provided by Macpower Digital Assets Edge formerly MDA Edge. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$65.00/hr - $65.00/hr

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 technologiesincluding Paxata, Tableau, MicroStrategy, Business Objects, and Ryou 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.
  
  

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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Staffing and Recruiting

Referrals increase your chances of interviewing at Macpower Digital Assets Edge formerly MDA Edge by 2x

Get notified about new Solutions Analyst jobs in Columbus, OH.

Data Collaboration Business Analyst - IT Research & Innovation

Columbus, OH $100,000.00-$120,000.00 1 week ago

Columbus, OH $159,000.00-$169,000.00 2 weeks ago

System Administrator(Epic Application Analyst) - Hybrid, OH

Business Analyst – SAP Work and Asset Management Implementation

Sr Disaster Recovery Technical Analyst (Contract to Hire)

Epic Analyst (Information Technologist 3) - 20100714

Power Platform Functional Senior Consultant

Columbus, OH $74,100.00-$147,800.00 1 week ago

Solutions Architect – SAP Work and Asset Management Implementation

Resolution and Recovery Business Analyst, Senior Associate

Columbus, OH $63,000.00-$124,000.00 4 days ago

Sr. Enterprise Architect - Customer / Corporate Solutions

Columbus, OH $129,500.00-$194,300.00 4 weeks ago

Full time Business Analyst with Credit Card Migration Experience – Remote till pandemic

Technical Azure DevOps-AWS Consultant - Hybrid, OH

Sr. Analyst, Regional Internal Consultant - Retirement Solutions

Delivery Solutions Architect - Digital Native Business

Principal Enterprise Architect - Customer / Corporate Solutions

Columbus, OH $155,400.00-$233,100.00 1 month ago

Microsoft D365 Supply Chain Management Business Analyst - Senior - Consulting - Location OPEN

Columbus, OH $102,500.00-$187,900.00 16 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.