Data Warehouse Developer

Company Description

The Office of Innovation & Technology (OIT) is the central IT agency for the City of Philadelphia and is led by the Chief Information Officer (CIO). OIT oversees all major information and communications technology initiatives for the City, aiming to increase the effectiveness of the IT infrastructure and make services advanced, optimized, and responsive to the needs of residents, businesses, and visitors.

The mission of the Department of Behavioral Health and Intellectual Disability Services (DBHIDS) is to educate, strengthen, and serve individuals and communities so that all Philadelphians can thrive. We work with persons recovering from mental health and/or substance use, individuals with intellectual disabilities, families, and service providers to ensure that high quality services are accessible, effective and appropriate. We are committed to developing a system of care that is data-driven, employs evidence-based practices, promotes cultural competence and eliminates health care disparities.

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.

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)

• Bachelor's 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.
• 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: $65,000 - $75,000

Salary cannot exceed $75,000.

All applications should include the following:

• Cover Letter clarifying your interest and qualifications for the role. • Resume

We won't 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. • 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. • 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!

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 215-686-4670 or send an email to [email protected].