Duties and Responsibilities:

• Responsible for performing data analysis and problem solving with Business Intelligence (BI) software and systems
• Provide production support, troubleshooting, and maintenance to database environments, data loads, etc.
• Establishes the data management framework that improves the data quality and standards for both database structures and the warehouse repository
• Reviews, understands and documents the current operational processes and data sources to establish support for current and future reporting requirements
• Develops requirements for data mapping and data loading processes
• Executes data mapping/loading requirements and reconcilement of such activities
• Assists with the development of data model(s) for the data repository guided by the data warehouse architect
• Provides recommendations for all data strategies and out of scope processes
• Performs analysis and designs mapping logic between source systems and the Enterprise Data Warehouse.
• Analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems or as part of the ETL process

Skills and Requirements: 

• Experience with reporting tools such as SSRS and Power BI
• Sharp analytical and problem-solving skills
• Strong ability to manage multiple projects simultaneously and adapt to rapidly changing priorities
• Excellent verbal and written communication skills and excellent customer service skills
• Proven ability to work in a team and to foster teamwork
• Demonstrated understanding of system integrations and database structures