Provide support to the Data Platform Lead Practitioner for all Data Platform activity for one or more business areas

Key Roles and Responsibilities

Works directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applications. Determines and documents data mapping rules for movement of medium to high complexity data between applications. Adheres to and promotes the use of data administration standards. Supports data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts. Creates and sustains processes, tools, and on-going support structures and processes. Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data. Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function. Creates and populates meta-data into repositories. May create data models, including robust data definitions, which may be entity- relationship-attribute models, star, or dimensional models. May also create data flow diagrams and process models and integrates models across functional areas and platforms. Works closely with DBAs to transition logical models to physical implementation. May be responsible for employing data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis. May also be responsible for quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance.

Qualifications

Preferred Bachelors degree in Information Systems, Engineering, Math, or Sciences; Data Analytics nanodegree; or equivalent experience.  Typically requires 5-8 years experience. Experience using Business Intelligence tools relevant to business area (such as PowerBI, Tableau) required. Strong knowledge of SQL with relational databases (such as Snowflake; Teradata; Vertica).Strong knowledge with Microsoft Office software

Preferred Skills:

• Excellent oral/written skills
• Experience using data warehouse/analytical tools for business purposes
  Strong knowledge of Business core processes/data required to drive those processes
• Strong understanding of source data (its strengths/weaknesses/ semantics/formats)
• Ability to work with/effectively communicate with people at all levels of the enterprise from Executives to developer
• Flexibility/diplomacy/problem-solving skills
• Ability to translate business requirements into technical requirements
• Ability to effectively work independently/motivated; ability to handle multiple priorities

• Data Governance
• Data Mining
• Data Movement Tools
• Data Warehousing
• Emerging Technologies
• ETL Process
• Information Management
• Modeling: Data, Process, Events, Objects
• Query and Database Access Tools
• Relational Databases
• Scripting Tools and Languages
• System and Technology Integration