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