Sr. Data Warehouse Developer
Apply NowCompany: Harris County, TX
Location: Houston, TX 77084
Description:
Salary: Depends on Qualifications
Location : Houston, TX
Job Type: Regular Full-time
Job Number: 14191
Department: Universal Services
Opening Date: 01/03/2025
Closing Date: 6/16/2025 11:59 PM Central
Max Number of Applicants: 250
Position Description
Position Overview:
The Senior Data Warehouse Developer works with business and technical teams to provide subject matter expertise in the design and development of Business Intelligence solutions. You will be responsible for designing, developing, and maintaining data warehouse solutions using both on-premises and cloud-based technologies.
Job Duties:
Harris County is an Equal Opportunity Employer https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net. This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.
Requirements
Education:
Experience:
Knowledge, Skills, and Abilities (KSAs):
Applicants for this position will be subject to a criminal background check that includes being fingerprinted. This applies to any position with network access to Criminal Justice Information Services (CJIS) or access to an area where CJIS is received, maintained or stored either manually or electronically (i.e. custodian, maintenance). Automatic Disqualification:
NOTE: Qualifying education, experience, knowledge and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.
Preferences
Experience:
Knowledge, Skills, and Abilities (KSAs):
General Information
Location:
Work Schedule:
Work Arrangement:
Employment may be contingent on passing a drug screen and meeting other standards. Due to a high volume of applications positions may close prior to the advertised closing date or at the discretion of the Hiring Department.
BENEFITS
Harris County offers a competitive benefits program, including comprehensive group health and related benefits plan as well as defined benefit retirement plan.
The following list of benefits is offered only to employees in regular (full-time) positions:
The following benefits are also available to regular (full-time) employment and may be available to part-time employees:
In accordance with the Harris County Personnel Regulations, Group Health and related benefits are subject to amendment or discontinuance at any time. Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.
For plan details, visit the Harris County benefits website:
01
Which of the following best describes your highest level of education completed as it relates to this position?Qualifying information must be documented in the Education section of your application.
02
If you selected a college degree in response to the previous question, which of the following best describes your major?
03
Please describe your educational background including level of education completed, area of study and completed major and minor programs.
04
Which of the following best describes your verifiable experience as a data warehouse developer, business intelligence developer, or equivalent role? (To be considered, qualifying experience must be documented in your application's employment history)
05
Please provide the dates of employment during which you obtained experience working as a data warehouse developer, business intelligence developer, or equivalent role. Provide the month and year that began and ended the experience. Example: "January 2020 - December 2023" If this experience is not clearly documented in the Work Experience section, your application will be disqualified. If you do not have this experience, type "N/A" in the space provided.
06
Which of the following best describes your verifiable experience with Matillion/Azure Data Factory or similar ETL tools? (To be considered, qualifying experience must be documented in your application's employment history)
07
Please provide details about your verifiable experience with Matillion/Azure Data Factory or similar ETL tools.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
08
Which of the following best describes your verifiable experience with Snowflake and other cloud warehouses? (To be considered, qualifying experience must be documented in your application's employment history)
09
Please provide details about your verifiable experience with Snowflake and other cloud warehouses.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
10
Which of the following best describes your verifiable experience with Power BI?(To be considered, qualifying experience must be documented in your application's employment history)
11
Please provide details about your verifiable experience with Power BI.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
12
Do you have one (1) year of experience with Matillion?
13
Which of the following describes your level of proficiency using a personal computer and common office software such as MS Office Suite (Word, Excel, PowerPoint, and Outlook). Please select your level of proficiency based on the following descriptions:Advanced:A person with this level of skills is able to produce very large, complex formal documents that require a table of contents, footnotes, endnotes, bookmarks, and other special elements; a wide range of graphic effects, and use advanced techniques for analyzing and manipulating data. Has full mastery of Macro commands and skills to tie the objects together into a cohesive system by using Macros and Visual Basic for Applications code. Makes interactive presentations by using hyperlinks and action buttons.Intermediate:A person with this level of skills is able to customize toolbars, import and insert graphs, embed Excel data, and elaborate reports. Understands the concepts of databases and is able to work with charts and to use the list management capabilities of Excel. Able to use complex query techniques, create efficient forms and reports, and create Macros to automate these forms. Makes interactive presentations by using hyperlinks and action buttons.Basic:A person with this level of skills is able to use basic formatting, editing, printing functions, and understands the document page setup. Has the ability to enter and correct data, modify a workbook, format a worksheet, and use printing functions. Understands the different database concepts and structures and is familiar with data validation and is able to create a simple presentation in PowerPoint, run it, and print it.Entry Level:A person with this level of skills has the ability to open, create, save and modify documents in Word, send and receive email in Outlook and create spreadsheets in Excel. Format documents for printing, comfortable using the printer menu to preview documents. Has ability to change the font, the margins, insert or delete pages and use the built-in spellchecker and grammar check.
Required Question
Location : Houston, TX
Job Type: Regular Full-time
Job Number: 14191
Department: Universal Services
Opening Date: 01/03/2025
Closing Date: 6/16/2025 11:59 PM Central
Max Number of Applicants: 250
Position Description
Position Overview:
The Senior Data Warehouse Developer works with business and technical teams to provide subject matter expertise in the design and development of Business Intelligence solutions. You will be responsible for designing, developing, and maintaining data warehouse solutions using both on-premises and cloud-based technologies.
Job Duties:
- Gather business requirements and create architectural designs.
- Develop new ETL/ELT processes using Azure Data Factory and Matillion.
- Support existing ETL solutions leveraging SSIS.
- Develop standards and best practices for loading data from and into different source/target systems.
- Develop dashboards and reports using Power BI.
- Provide subject matter expertise in data modeling, data warehousing, and data ingestion methods.
- Performs the design and extension of data marts, meta data, and data models.
- Translates requirements and data mapping documents to technical designs.
- Gains an understanding of the enterprise data warehousing best practices and standards.
- Performs data analysis, data profiling, and reviews current environment to meet specific customer requirements.
- Collaborates with cross-functional teams (QA, Production, DBAs) to address data-related issues and requirements.
- Manage data warehouse databases, ensuring that data is consistent, accurate, and accessible.
- Monitor the performance of the data warehouse and make optimizations to improve speed and efficiency.
Harris County is an Equal Opportunity Employer https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net. This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate.
Requirements
Education:
- Bachelor's degree in computer science, management information systems, or another related field
Experience:
- 5+ years of experience as a data warehouse developer, business intelligence developer, or equivalent role.
- 5+ years of experience with Matillion/Azure Data Factory or similar ETL tools.
- 3+ years of experience with Snowflake and other cloud warehouses.
- 3+ years of experience with Power BI.
- Experience with Agile methodology and working on an Agile team.
Knowledge, Skills, and Abilities (KSAs):
- Strong problem-solving skills
- Strong communication skills (written and verbal)
- Experience in full cycle delivery of data warehouse projects.
- Expert in SQL language and writing complex logic using SQL
- Knowledge of stored procedures and functions in Snowflake
- Expert in dimensional modeling
- Knowledge of Azure DevOps and Git for source control, deployments, and scrum boards.
Applicants for this position will be subject to a criminal background check that includes being fingerprinted. This applies to any position with network access to Criminal Justice Information Services (CJIS) or access to an area where CJIS is received, maintained or stored either manually or electronically (i.e. custodian, maintenance). Automatic Disqualification:
- Convictions, probation, or deferred adjudication for any Felony, and any Class A Misdemeanor
- Convictions, probation, or deferred adjudication for a Class B Misdemeanor, if within the previous 10 years
- Open arrest for any criminal offense (Felony or Misdemeanor)
- Family Violence conviction
NOTE: Qualifying education, experience, knowledge and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications.
Preferences
Experience:
- 1+ year of Matillion experience preferred.
Knowledge, Skills, and Abilities (KSAs):
- Azure Data Lake storage, Azure Databricks, Deployment pipelines in Azure DevOps.
- Skills in data analysis, programming (e.g., Python, R), statistics, machine learning, data visualization, problem-solving, and domain expertise to derive actionable insights from data.
- Familiarity with Python and other programming languages for database automation.
General Information
Location:
- 1111 Fannin St., Houston, Texas 77002
Work Schedule:
- 8 hours/day
Work Arrangement:
- Hybrid
Employment may be contingent on passing a drug screen and meeting other standards. Due to a high volume of applications positions may close prior to the advertised closing date or at the discretion of the Hiring Department.
BENEFITS
Harris County offers a competitive benefits program, including comprehensive group health and related benefits plan as well as defined benefit retirement plan.
The following list of benefits is offered only to employees in regular (full-time) positions:
- Medical Coverage
- Dental Coverage
- Vision Coverage
- Wellness Plan
- Life Insurance
- Long-term disability
- Employee Assistance Program
- Ten (10) days of vacation each year for the first five (5) years of service
- Accrual rates increase based on years of service
- Eleven (11) County-observed holidays and one (1) floating holiday
- Professional development opportunities
- Dependent Care Reimbursement Plan
- Healthcare Reimbursement Account
- 457 Deferred Compensation Plan
The following benefits are also available to regular (full-time) employment and may be available to part-time employees:
- Retirement Pension (TCDRS)
- Flexible schedule (varies by department)
- Transportation Assistance (Metro RideSponsor Program)
In accordance with the Harris County Personnel Regulations, Group Health and related benefits are subject to amendment or discontinuance at any time. Commissioners Court reserves the right to make benefit modifications on the County's behalf as needed.
For plan details, visit the Harris County benefits website:
01
Which of the following best describes your highest level of education completed as it relates to this position?Qualifying information must be documented in the Education section of your application.
- High School or GED diploma
- Associate Degree
- Bachelor's Degree
- Master's Degree or higher
- None of the above
02
If you selected a college degree in response to the previous question, which of the following best describes your major?
- Computer Science
- Management Information Systems
- Other Related Field
- Unrelated Field
- N/A; No Degree
03
Please describe your educational background including level of education completed, area of study and completed major and minor programs.
04
Which of the following best describes your verifiable experience as a data warehouse developer, business intelligence developer, or equivalent role? (To be considered, qualifying experience must be documented in your application's employment history)
- Less than five (5) years
- Five (5) years but less than six (6) years
- Six (6) years but less than seven (7) years
- Seven (7) years or more
- I do not have this experience
05
Please provide the dates of employment during which you obtained experience working as a data warehouse developer, business intelligence developer, or equivalent role. Provide the month and year that began and ended the experience. Example: "January 2020 - December 2023" If this experience is not clearly documented in the Work Experience section, your application will be disqualified. If you do not have this experience, type "N/A" in the space provided.
06
Which of the following best describes your verifiable experience with Matillion/Azure Data Factory or similar ETL tools? (To be considered, qualifying experience must be documented in your application's employment history)
- Less than five (5) years
- Five (5) years but less than six (6) years
- Six (6) years but less than seven (7) years
- Seven (7) years or more
- I do not have this experience
07
Please provide details about your verifiable experience with Matillion/Azure Data Factory or similar ETL tools.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
08
Which of the following best describes your verifiable experience with Snowflake and other cloud warehouses? (To be considered, qualifying experience must be documented in your application's employment history)
- Less than three (3) years
- Three (3) years but less than four (4) years
- Four (4) years but less than five (5) years
- Five (5) years or more
- I do not have this experience
09
Please provide details about your verifiable experience with Snowflake and other cloud warehouses.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
10
Which of the following best describes your verifiable experience with Power BI?(To be considered, qualifying experience must be documented in your application's employment history)
- Less than three (3) years
- Three (3) years but less than four (4) years
- Four (4) years but less than five (5) years
- Five (5) years or more
- I do not have this experience
11
Please provide details about your verifiable experience with Power BI.Do not use "Please see Resume" or "See Resume"(To be considered, qualifying experience must be documented in your application's employment history)Please include your (a) role(s), (b) types of organizations, (c) scope of duties and responsibilitiesIf you do not have this experience, please type "None" in the space provided.
12
Do you have one (1) year of experience with Matillion?
- Yes
- No
13
Which of the following describes your level of proficiency using a personal computer and common office software such as MS Office Suite (Word, Excel, PowerPoint, and Outlook). Please select your level of proficiency based on the following descriptions:Advanced:A person with this level of skills is able to produce very large, complex formal documents that require a table of contents, footnotes, endnotes, bookmarks, and other special elements; a wide range of graphic effects, and use advanced techniques for analyzing and manipulating data. Has full mastery of Macro commands and skills to tie the objects together into a cohesive system by using Macros and Visual Basic for Applications code. Makes interactive presentations by using hyperlinks and action buttons.Intermediate:A person with this level of skills is able to customize toolbars, import and insert graphs, embed Excel data, and elaborate reports. Understands the concepts of databases and is able to work with charts and to use the list management capabilities of Excel. Able to use complex query techniques, create efficient forms and reports, and create Macros to automate these forms. Makes interactive presentations by using hyperlinks and action buttons.Basic:A person with this level of skills is able to use basic formatting, editing, printing functions, and understands the document page setup. Has the ability to enter and correct data, modify a workbook, format a worksheet, and use printing functions. Understands the different database concepts and structures and is familiar with data validation and is able to create a simple presentation in PowerPoint, run it, and print it.Entry Level:A person with this level of skills has the ability to open, create, save and modify documents in Word, send and receive email in Outlook and create spreadsheets in Excel. Format documents for printing, comfortable using the printer menu to preview documents. Has ability to change the font, the margins, insert or delete pages and use the built-in spellchecker and grammar check.
- Advanced
- Intermediate
- Basic
- Entry Level
- Not proficient
Required Question