Sr Data Warehouse Developer
Sr Data Warehouse Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 onpremises and cloudbased 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 crossfunctional teams (QA Production DBAs) to address datarelated 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 If you need special services or accommodations please callor email.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:
Bachelors 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 problemsolving 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 butONLY 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 problemsolving 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.
Required Experience:
Senior IC
Employment Type
Full-Time
