Extremely visible role within organization, cross-functual opportunity with significant interaction with the IT department.
Responsible for direct interaction with the Business Analysts, Development, DBA team and End User to gain a thorough understanding of the data being requested and mapping it from the third parties and into internal data structures. Converts data when needed, and provide requested data to Development teams.
Responsible for working directly with the third party data staff to develop the requested data interfaces.
Responsible for testing the data received from the Third Party Systems for accuracy of format and conversion definitions.
Work with Developers to automate reports and processes.
Data Mart Design
Responsible for the collection, analysis, interpretation and summarization of data in the generation of data marts and repositories.
Designs and or develops database objects (databases, tables, stored procedures, DTS Packages) to support the collection, tracking and reporting of business data.
Designs, develops and supports reporting tools that utilize advanced features in MS Excel and MS Access, i.e. VBA, macros.
1+ years experience in SSIS/ETL, data analytics and reporting.
Experience with developing logical and physical data models.
Experienced with data warehousing, data marts and dashboards.
Experienced with MS SQL and/or Oracle.
Ability to use SQL development tools such as SQL Management Studio and Toad as well as maintain code in source code control systems.
Experience implementing and/or working with Meta Data a plus.
Experience working with Informatica IDQ.
Experience working with XML files for data ingestion.
Experience with database design/modeling tools such as Erwin.
Familiar with Big Data, Master Data Management strongly preferred.
Previous experience with Tableau a plus.
Strong technical documentation skills.
Knowledge of data integrity protocols and security requirements and techniques.