Address
Form of workCompany Description
A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you're interested in working with a passionate team of people who care about the future of Philadelphia, start here.
What We Offer:
Impact - The work you do here matters to millions.
Growth - Philadelphia is growing, why not grow with it?
Diversity & Inclusion - Find a career in a place where everyone belongs
Benefits - We care about your well being
Job Description
The Data Warehouse Administrator assists in the process automation, the daily updating of the data using SSIS from an Oracle RDB database to a SQL Server 2014 or later database, and SQL Server 2014 or later database administration. The position is involved in the operation, maintenance, and on-going development of the jail management application. The successful candidate will need to be able to write extensive SQL Query statements. This position is responsible for the monitoring and performance of reports. The Data Warehouse Administrator position is also responsible for the technical aspects of a data warehouse, primarily administering databases and resolving all issues to ensure data accuracy. The Data Warehouse Administrator will perform data warehouse design and construction; perform extensive testing, as well as ETL and repository creation. This position will coordinate with other team members and managers to translate business needs into technical solutions.
Essential Functions
•ETL (Extract, Transform, and Load): Monitor and safeguard the ETL process to extract the data from Lock and Track into a data warehouse Staging area using SSIS as well as to implement additional data sets from new data sources.
•Monitoring and safeguarding the ETL process to move the data from the Staging area into the data warehouse star schema using SSIS. Maintain and enhance the business rules and transformations that will be utilized to cleanse and standardize the data
•Design and implementation of aggregate tables, views, and virtual tab
•SQL Server Database Administration: Perform aspects of database administration to support optimal performance of the data warehouse
•Handling of routine operational issues that come up with the data warehouse
•Responsible for working with the MIS staff for backup and recovery procedures
•Creating SSIS scripts including ETL packages
•Building SSRS reports with Visual Studio
•Data modeling
•Supporting Windows 2012-2019 Server Operating Environments
•Supporting Microsoft SQL Server 2014 or later
•Supports IJMS (Lock & Track) Operating Environment
•Training MIS Support Staff
•Provides feedback on software licensing needed for the position
•Works with Central OIT staff and contracted staff on operations and project work
•Provides end-users training
•Knowledge of SSRS environment support
•Maintains Reporting Intranet site
Competencies, Knowledge, Skills and Abilities
•Microsoft SQL Server 2014 or later database
•Microsoft SQL Server 2014 or later SSIS (Data Transformation Services)
•Standard Query Language (SQL)
•Oracle RDB 7.3 (Backup and Recovery)
•SQL (Backup and Recovery)
•PostgreSQL 12
•ODBC connectivity
•Technical Documentation
•SQL for Oracle RDB 7.3
•OpenVMS 8.4 or later
•Extract Transformation and Load (ETL)
•Data access management using Active Directory and securing reports
•Query writing to business level requirements
•Data governance
Qualifications
•Establish and maintain effective working relationships with associates, departmental officials and outside consultants;
•Analyze and present complex data structures;
•Learn the operations, functions, data and reporting needs and business requirements;
•Learn the regulations, ordinances, policies and procedures related to the work of the Prisons;
•Read, interpret and understand technical information and apply cross-functional knowledge;
•Effectively present information and respond to questions from managers, co-workers and system users;
•May assist with planning, organizing, and directing the work activities of outside consultants and/or systems analysts and programming personnel assigned on a team;
•Advise OIT and Prisons management with respect to systems development projects and/or enhancements
•Job Scheduling (creation, modifying and monitoring);
•Microsoft Access 2016
•Web development with knowledge of HTML, CSS, JavaScript, and PHP (Preferred);
Additional Information
Salary range: $75,000 - $85,000
Please submit a resume and cover letter with your application.
Did you know?
*The successful candidate must be a city of Philadelphia resident within six months of hire
Please note that effective September 1, 2021 the City of Philadelphia is requiring all new employees to present proof of vaccination against COVID-19.
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 faqpchr@phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx
A best-in-class city that attracts best-in-class talent, Philadelphia is an incredible place to build a career. From our thriving arts scene and rich history to our culture of passion and grit, there are countless reasons to love living and working here. With a workforce of over 30,000 people, and more than 1,000 different job categories, the City of Philadelphia offers boundless opportunities to make an impact.
As an employer, the City of Philadelphia values inclusion, integrity, innovation, empowerment, and hard work above all else. We offer a vibrant work environment, comprehensive health care and benefits, and the experience you need to grow and excel. If you're interested in working with a passionate team of people who care about the future of Philadelphia, start here.
What We Offer:
Impact - The work you do here matters to millions.
Growth - Philadelphia is growing, why not grow with it?
Diversity & Inclusion - Find a career in a place where everyone belongs
Benefits - We care about your well being
Job Description
The Data Warehouse Administrator assists in the process automation, the daily updating of the data using SSIS from an Oracle RDB database to a SQL Server 2014 or later database, and SQL Server 2014 or later database administration. The position is involved in the operation, maintenance, and on-going development of the jail management application. The successful candidate will need to be able to write extensive SQL Query statements. This position is responsible for the monitoring and performance of reports. The Data Warehouse Administrator position is also responsible for the technical aspects of a data warehouse, primarily administering databases and resolving all issues to ensure data accuracy. The Data Warehouse Administrator will perform data warehouse design and construction; perform extensive testing, as well as ETL and repository creation. This position will coordinate with other team members and managers to translate business needs into technical solutions.
Essential Functions
•ETL (Extract, Transform, and Load): Monitor and safeguard the ETL process to extract the data from Lock and Track into a data warehouse Staging area using SSIS as well as to implement additional data sets from new data sources.
•Monitoring and safeguarding the ETL process to move the data from the Staging area into the data warehouse star schema using SSIS. Maintain and enhance the business rules and transformations that will be utilized to cleanse and standardize the data
•Design and implementation of aggregate tables, views, and virtual tab
•SQL Server Database Administration: Perform aspects of database administration to support optimal performance of the data warehouse
•Handling of routine operational issues that come up with the data warehouse
•Responsible for working with the MIS staff for backup and recovery procedures
•Creating SSIS scripts including ETL packages
•Building SSRS reports with Visual Studio
•Data modeling
•Supporting Windows 2012-2019 Server Operating Environments
•Supporting Microsoft SQL Server 2014 or later
•Supports IJMS (Lock & Track) Operating Environment
•Training MIS Support Staff
•Provides feedback on software licensing needed for the position
•Works with Central OIT staff and contracted staff on operations and project work
•Provides end-users training
•Knowledge of SSRS environment support
•Maintains Reporting Intranet site
Competencies, Knowledge, Skills and Abilities
•Microsoft SQL Server 2014 or later database
•Microsoft SQL Server 2014 or later SSIS (Data Transformation Services)
•Standard Query Language (SQL)
•Oracle RDB 7.3 (Backup and Recovery)
•SQL (Backup and Recovery)
•PostgreSQL 12
•ODBC connectivity
•Technical Documentation
•SQL for Oracle RDB 7.3
•OpenVMS 8.4 or later
•Extract Transformation and Load (ETL)
•Data access management using Active Directory and securing reports
•Query writing to business level requirements
•Data governance
Qualifications
•Establish and maintain effective working relationships with associates, departmental officials and outside consultants;
•Analyze and present complex data structures;
•Learn the operations, functions, data and reporting needs and business requirements;
•Learn the regulations, ordinances, policies and procedures related to the work of the Prisons;
•Read, interpret and understand technical information and apply cross-functional knowledge;
•Effectively present information and respond to questions from managers, co-workers and system users;
•May assist with planning, organizing, and directing the work activities of outside consultants and/or systems analysts and programming personnel assigned on a team;
•Advise OIT and Prisons management with respect to systems development projects and/or enhancements
•Job Scheduling (creation, modifying and monitoring);
•Microsoft Access 2016
•Web development with knowledge of HTML, CSS, JavaScript, and PHP (Preferred);
Additional Information
Salary range: $75,000 - $85,000
Please submit a resume and cover letter with your application.
Did you know?
- We are a Public Service Loan Forgiveness Program qualified employer
- 25% tuition discount program for City employees (and sometimes spouses and dependents as well) in partnership with area colleges and universities
- 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
*The successful candidate must be a city of Philadelphia resident within six months of hire
Please note that effective September 1, 2021 the City of Philadelphia is requiring all new employees to present proof of vaccination against COVID-19.
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 faqpchr@phila.gov. For more information, go to: Human Relations Website: http://www.phila.gov/humanrelations/Pages/default.aspx
