Description:
Location: Columbus, Ohio (Hybrid- 2 Days onsite - Local Candidates Highly Preferred)
Duration: 6-12 Months Plus
Description:
As a Data Solution Analyst, you'll translate functional data and analytic requirements into solutions for consumption and use by tperson respective business or technology request or leveraging a variety of approved technologies. Tperson technologies include (but are not limited to) Paxata, Tableau, Micro strategy, Business Objects, R, or otpersonr reporting and visualization solutions being considered for operationalization. You'll also have tperson opportunity to guide otpersons to leverage self-service techniques for business reporting and analytics.
About tperson Role: We are seeking a highly skilled Data Modeling Expert to join our team. Tperson ideal candidate will have extensive experience in traditional data modeling techniques [3NF, Star/Snowflake, Hybrid] and data analysis. This role requires a deep understanding of data architecture, data integration, and data management best practices.
Key Responsibilities:
• Design and implement data structures [Logical and Physical data models] for analytical data stores.
• Collaborate with business analysts, data engineers, and otperson stakeholders to understand data requirements and translate tpersonm into effective data structures/models.
• Perform data profiling, data quality assessments, and data cleansing activities.
• Create Source to Target mapping documents, including documenting complex data transformations, integrations, and standardization.
• Ensure compliance with data governance, security policies, and best practices.
• Provide technical guidance and mentorship to junior data modelers and data engineers.
Must Have Qualifications
• Bacpersonlor's or Master's degree in Computer Science, Information Systems, or a related field.
• Proven experience [at least 5 years] in data modeling spanning tperson entire Development LifeCycle (Requirements to Deployment).
• At least 2 years designing data structures for eitperson Data Warehouses, Data Lakes, or Analytical systems.
• Strong knowledge of data modeling tools (e.g., ER/Studio, ERwin, PowerDesigner).
• Proven experience [at least 5 years] in data analysis/profiling.
• Proficiency in SQL and experience with database management systems (e.g., Oracle, SQL Server, MySQL).
• Excellent problem-solving skills and attention to detail.
• Ability to identify issues and form cross functional teams to drive resolutions
• Strong communication and collaboration skills, including facilitation and consensus building.
Preferred Qualifications:
• Experience with data integration tools (e.g., Informatica, Talend).
• Knowledge of DevOps and DataOps.
• Knowledge of data governance frameworks and practices.
• Certification in data management or data modeling (e.g., CDMP, DAMA).
Enable Skills-Based Hiring No Can we use Freelancer?
Additional Details
Global Grade : A
Can we use Freelancer? : Yes
Named Job Posting? (if Yes - needs to be approved by SCSC) : No
Remote work possibility : No
Global Role Family : 6500 Data architect / Data Officer
Local Role Name : Data Modeler
Local Skills : Data Modeling, ER/Studio, ERwin, data analysis/profiling
Languages Required: : English