Data Warehouse Developer

Job Description
Under limited supervision, the Data Warehouse Developer (DWD) supports information integration and delivery needs for DBHIDS as part of the enterprise data warehouse (EDW) team. The DWD works collaboratively with business stakeholders, data architects, data management professionals and other analysts. The DWD is responsible for understanding the business definitions of data, where the data is collected, how it is published, and the technologies necessary to make it a useful resource for data consumers. As part of the EDW team, the DWD will support the activities of the enterprise business intelligence (BI) team as well as individual business unit analysts, and work on cross-unit EDW, BI, and master data management (MDM) projects. The DWD shall be responsible for:
- Developing data warehousing solutions consistent with the vision and direction of the department’s Data Governance Framework Strategic Plan.
- Designing, testing, implementing, and monitoring data integration programs to consume data from multiple sources, archive it, create load routines, and load it into an integrated data vault-based Kalido EDW implementation.
- Designing, testing, implementing, and monitoring data integration programs to publish data from the EDW into dimensional models, flat files, and proprietary structures to meet the needs for reporting, analytics, and external data requests.
- Working closely with the business intelligence unit and internal customers across DBHIDS to optimize reports and analytics capability using the Qliksense business intelligence platform.
- Working with data quality and business analysts to identify and resolve data issues through configuration of data cleansing and de-duplication software and the use of the Kalido MDM tools.
- Assisting in data analysis for data quality issues such as duplicate records or missing values by identifying data integration errors.
- Working with database administrators to ensure that the EDW is tuned for optimal performance.
- Working with business analysts to develop and refine reporting and analytics requirements.
- Maintaining data lineage through source-to-target mapping documentation and documenting rules and procedures required to transform, process, and load data into the EDW or into reporting solutions.
- Assisting with maintenance of an enterprise metadata management capability to integrate data dictionaries with the enterprise business glossary.
- Suggesting and implementing process changes to improve the overall data management effectiveness of the Department.
- Leveraging the department data integration and master data management environment as the primary source for analytical reporting solutions.
- Analyzing reporting requirements to determine if needed data already exists in the data warehouse environment or must be acquired.
- Determining ways to reuse data structures and processes to meet other reporting needs.
- Installing and configuring data integration and other data management software.
- Coordinating with application and network infrastructure personnel to ensure availability of the EDW and MDM environments.
- Establishing backup and recovery or replication plans for the EDW and MDM environments to minimize data loss and system downtime.
This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. This DWD role requires a service-oriented mentality, a high sense of ownership of the problems and requests assigned, a focus on managing and resolving issues in alignment with expectations, establishing and maintaining communication with database stakeholders to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. The DWD must be capable of working both independently and collaboratively.
Essential Functions
- Data Integration Support:
identify data warehouse sources, map them to data warehouse and reporting structures, and develop and maintain the required data integration processes.
- EDW Platform Support:
in cooperation with other technologists, provide installation, configuration, and administration for EDW and data management tools.
- BI Reporting Solutions:
assist with development efforts for operational and analytical reporting solutions from an enterprise data warehousing environment.
- BI Platform Support:
in cooperation with other technologists, assist with installation and configuration of BI and reporting tools.
- Applied Research:
perform directed research on various EDW and data management subjects.
Competencies, Knowledge, Skills and Abilities
- Proficiency in the use of structured query language (SQL).
- Proficiency in Microsoft Office to include Word, Excel, and Outlook, and PowerPoint or comparable productivity software.
- Proficiency in the use of various data modeling, data management, and general productivity tools and technologies.
- Strong organizational and administrative skills including prioritizing, multi-tasking, and keeping track of information or work in progress while ensuring accuracy.
- Strong time management, problem solving, and project management skills.
- Knowledge of supervisory principles, practices, and techniques.
- Knowledge of the principles and practices of designing, developing, implementing, maintaining, evaluating, and controlling operational and analytical reporting solutions.
- Knowledge of BI software and other reporting tools;
Qlik Sense experience strongly desired.
- Knowledge of the concepts of database management, database design, and internal data security mechanisms.
- Knowledge of information technology and familiarity with information design patterns, technology practices, policies, and procedures.
- Knowledge of current principles and best practices of data management within large organizations.
- Ability to install, configure, optimize and manage BI and reporting technologies.
- Ability to design, write, test, troubleshoot and execute SQL scripts and queries.
- Ability to create a dimensional model based upon business requirements, and to create and implement an efficient database design from application specifications.
- Ability to develop complex queries and create reports based on user needs and requirements.
- Ability to communicate effectively and coordinate activities with other information technology staff in the development of complex reporting solutions.
- Ability to communicate effectively between subject matter experts and developers to ensure accurate translation of business needs to implementation efforts.
- Ability to identify and communicate risks to project timetables, deliverables, or scope.
- Ability to analyze problem conditions affecting data quality or the performance of reporting solutions, and then arrive at realistic solutions.
- Ability to prepare clear, accurate and informative reports and documentation on BI or reporting matters.
- Ability to promote and value diversity and understand multicultural and cultural competencies;
ability to work effectively with management, technologists, business staff and other stakeholders from different backgrounds.
- Ability to adapt to changing business needs, conditions, and work responsibilities;
responds to change witha positive attitude and a willingness to learn new ways to accomplish work activities and objectives.
- Ability to apply professional judgment in complex situations and handle effectively multiple tasks, initiatives and priorities.