Data Warehouse Developer

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 departments 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.

Qualifications :

Qualifications (Education and Experience)

• Bachelors Degree (coursework in Data Analysis Information Management Computer Science or Information Technology preferred).
• Three (3) years of experience in implementing data management solutions in a large heterogeneous organization including design development performance evaluation modification security backup version control and quality assurance. Experience with Microsoft SQL Server database platform is preferred. A graduate degree with coursework in Information Management or Information Technology can be substituted for two years of experience.
• Other combinations of education and experience may be evaluated on a case-by-case basis.

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 with a 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.

Additional Information :

Salary Range: $65000 - $75000 

Salary cannot exceed $75000.

All applications should include the following: 
    Cover Letter clarifying your interest and qualifications for the role.
    Resume
We wont accept or review incomplete applications.

Work Setting: in-person (onsite)

Discover the Perks of Being a City of Philadelphia Employee:
   We offer Comprehensive health coverage for employees and their eligible dependents
   Our wellness program offers eligibility into the discounted medical plan
   Employees receive paid vacation sick leave and holidays
   Generous retirement savings options are available
   Pay off your student loans faster - As a qualifying employer City of Philadelphia employees are eligible to participate in the Public Service Loan Forgiveness program. Join the ranks of hundreds of employees who have already benefited from this program and achieved student loan forgiveness.
   Enjoy a Free Commute on SEPTA - Starting September 1 2023 eligible City employees will no longer have to worry about paying for SEPTA public transportation. Whether youre a full-time part-time or provisional employee you can seize the opportunity to sign up for the SEPTA Key Advantage Program and receive free Key cards for free rides on SEPTA buses trains trolleys and regional rails.
   Unlock Tuition Discounts and Scholarships - The City of Philadelphia has forged partnerships with over a dozen esteemed colleges and universities in the area ensuring that our employees have access to a wide range of tuition discounts and scholarships. Experience savings of 10% to 40% on your educational expenses extending not only to City employees but in some cases spouse and dependents too!
Join the City of Philadelphia team today and seize these incredible benefits designed to enhance your financial well-being and personal growth!

*The successful candidate must be a city of Philadelphia resident within six months of hire

Effective May 22 2023 vaccinations are no longer required for new employees that work in non-medical non-emergency or patient facing positions with the City of Philadelphia. As a result only employees in positions providing services that are patient-facing medical care (ex: Nurses doctors emergency medical personnel) must be fully vaccinated.

The City of Philadelphia is an Equal Opportunity employer and does not permit discrimination based on race ethnicity color sex sexual orientation gender identity religion national origin ancestry age disability marital status source of income familial status genetic information or domestic or sexual violence victim status. If you believe you were discriminated against call the Philadelphia Commission on Human Relations at or send an email to
 

Remote Work :

No

Employment Type :

Full-time