Data Analyst/Modeler

The primary task of this individual will be creating source-to-target mappings in Erwin Mapping Manager based on existing documentation. However, the ideal candidate will be a well-rounded data analyst with the following background...

• Proficient in creation of source-to-target data mappings; mapping of tables, files, XML schemas, etc. from source to target; experience with Erwin Mapping Manager would be a huge plus
• Proficient in data modeling for both transactional and dimensional data warehouse databases
• Prefer knowledge of and applied use of Kimball Data Warehouse Methodology
• Experience using a standard data modeling toolset; prefer working knowledge of Erwin Data Modeler and Mart
• Data mining skills (including data auditing, aggregation, validation and reconciliation)
• 2 years' experience coding in a development language such as Data Stage, Python, C , or other language is a plus
• Strong ability to work with SQL databases; (SQL Server, Azure Synapse and / or Netezza DBMS a plus)
• Working knowledge of Azure Synapse Cloud Platform and data components is a plus
• Knowledge of real-time analytics and BI platforms such as Tableau and / or Power BI
• Data Analysis experience with data profiling and data validation
• Understanding of Data Quality (DQ) concepts and familiarity with DQ tools and methods; experience working on an active Data Governance Program is a plus
• Ability to communicate with customers to obtain data requirements and perform data analysis on data provided
• Strong oral and written communication skills - a MUST
• Ability to communicate complex findings and ideas in plain language
• Ability to work with teams towards a shared goal
• Ability to change direction quickly based on data analysis and / or architecture direction
• Ability to proactively seek clarification of requirements and direction to gain optimal solutions

Required Skills : 2 days per week onsite in Kansas City Erwin Source to Target Mapping Data Modeling Data Governance

Basic Qualification : 2 days per week onsite in Kansas City

Additional Skills : 2 days per week onsite in Kansas City

Background Check : Yes

Drug Screen : Yes

Notes :

Selling points for candidate :

Project Verification Info :

Candidate must be your W2 Employee : No

Exclusive to Apex : No

Face to face interview required : No

Candidate must be local : Yes

Candidate must be authorized to work without sponsorship : : No

Interview times set : Yes

Type of project : Administration / Support

Master Job Title : Data Analyst

Branch Code : Kansas City