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

N3N2UGc1T1FOcnlYWnBaNWltWFZoejVUTnc9PQ==
  • Macpower Digital Assets Edge
  • Columbus, OH

Job Description

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

Job Tags

Similar Jobs

Alutiiq

Landscaper Job at Alutiiq

 ...POSITION OVERVIEW AND PRIMARY DUTIES AND RESPONSIBILITIES (ESSENTIAL FUNCTIONS): ALMS is seeking a dedicated and skilled Landscaper to manage and maintain the grounds of our installation. Responsibilities include lawn maintenance, vegetation removal, and debris removal... 

Virtual Medical

REMOTE F/T OVERNIGHT RN TELEPHONE TRIAGE (NYS LICENSED) Job at Virtual Medical

 ...assessment, guidance, and disposition to the appropriate level of care. We work closely with our team of RN's and providers to...  ...care instructions, tele medicine visit with a provider or advise, Urgent Care, ER or 911 level of care required. ****MUST LIVE WITHIN A 2... 

Savills North America

Senior Public Relations Manager Job at Savills North America

 ...results. When you join Savills, our ask for you is simple: Be extraordinary, together. ABOUT THE ROLE: The Senior Public Relations Manager will lead and execute strategic communications initiatives to enhance Savills' reputation, increase brand awareness... 

Lensa

Recruiter Job at Lensa

 ...helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes...  ...goals are met. At a minimum, the position requires a good working knowledge of general office functions; excellent customer service... 

Apple Chrysler Dodge Jeep Ram

Automotive Parts Manager Job at Apple Chrysler Dodge Jeep Ram

Automotive Parts Manager CDJRCompany: Apple Autos (Top Minnesota Workplace)Compensation: $66,000.00 -$120,000.00Are you looking for a company that Supports You and Your Family, Encourages You to Make a Difference, and helps Champion Your Lifelong Journey? Then...