Denton County Transportation Authority
Data Warehouse Developer
Denton County Transportation Authority, Lewisville, Texas, us, 75029
Description
Under the direction of the Enterprise Application Manager, the Data Warehouse Developer is a detail-oriented and technically skilled individual who will lead the design, development, and maintenance of enterprise data integration and reporting solutions. This hybrid role emphasizes SQL-based Extract, Transform, Load (ETL) development and data modeling to support the agency's centralized data warehouse and cross-departmental reporting needs. The position is responsible for building robust, scalable ETL pipelines to unify data from disparate operational systems, ensuring consistent, high-quality data is available for analytics and decision-making. Additionally, the role includes supporting enterprise applications (ERP, asset management, etc.) with a focus on data integrity, reporting integration, and process optimization.
ESSENTIAL FUNCTIONS
The following duties are standard for this position. The omission of specific statements of duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification.
•Design, develop, and manage end-to-end SQL-based ETL processes to ingest and transform data from ERP, CAD/AVL, APC, fare systems, and other operational sources.
•Build and optimize data models, views, stored procedures, and scripts in Microsoft SQL Server or similar platforms to support a scalable enterprise data warehouse.
•Implement and monitor automated ETL workflows, ensuring reliability, accuracy, and performance of scheduled data pipelines.
•Collaborate with business units to define data requirements and translate them into reliable, well-structured datasets for self-service reporting and analysis.
•Develop and maintain reporting and dashboard solutions using tools such as Power BI, SSRS, or Tableau.
•Participate in data governance efforts by documenting transformation logic, managing metadata, and ensuring data consistency and security across systems.
•Provide Tier 1 and Tier 2 technical support for core enterprise systems, focusing on data integrity, reporting alignment, and API/data integration troubleshooting.
•Assist in application upgrades and configurations with a focus on how changes impact data flows and reporting.
•Work closely with the Enterprise Application Manager to align data infrastructure with long-term business intelligence strategies.
Requirements
QUALIFICATION GUIDELINES
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Where applicable, an equivalent combination of education and experience may be considered in lieu of education/experience listed below.
Education/Experience
•Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field.
•Minimum of 5 years of hands-on experience with SQL development and ETL pipeline creation in a business intelligence or data engineering role.
•Strong proficiency in T-SQL and experience working with large, complex datasets in a relational database environment.
•Experience with ETL tools and frameworks (e.g., SSIS, Azure Data Factory, custom scripting).
•Familiarity with reporting/visualization tools such as Power BI, SSRS, or Tableau.
•Ability to troubleshoot data issues and communicate technical details clearly to non-technical stakeholders.
•Strong analytical skills and attention to data quality, performance, and maintainability. Preferred Qualifications
•Experience with Microsoft SQL Server, including performance tuning and job automation.
•Familiarity with Azure data tools, including Data Factory, Synapse, or Blob Storage.
•Knowledge of ERP platforms such as Tyler Munis or similar public sector systems.
•Understanding of public transit data structures (e.g., GTFS, NTD) and experience integrating data from operational and planning systems.
•Exposure to data governance frameworks, ITIL principles, or cybersecurity practices.
PHYSICAL ACTIVITIES
:
Physical activity includes, but is not limited to: on a continuous basis, sit at a desk for long periods of time; intermittently twist and reach office equipment; write or use keyboard to communicate through written means; lift moderate weight; reaching above the waist, reaching below the waist, and reaching waist to shoulder to reach inventory on shelves; repetitive motion and fingering when using a computer keyboard; talking and hearing when dealing with customers; and observation of transit projects and operations during field work along the right-of-way.
Under the direction of the Enterprise Application Manager, the Data Warehouse Developer is a detail-oriented and technically skilled individual who will lead the design, development, and maintenance of enterprise data integration and reporting solutions. This hybrid role emphasizes SQL-based Extract, Transform, Load (ETL) development and data modeling to support the agency's centralized data warehouse and cross-departmental reporting needs. The position is responsible for building robust, scalable ETL pipelines to unify data from disparate operational systems, ensuring consistent, high-quality data is available for analytics and decision-making. Additionally, the role includes supporting enterprise applications (ERP, asset management, etc.) with a focus on data integrity, reporting integration, and process optimization.
ESSENTIAL FUNCTIONS
The following duties are standard for this position. The omission of specific statements of duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification.
•Design, develop, and manage end-to-end SQL-based ETL processes to ingest and transform data from ERP, CAD/AVL, APC, fare systems, and other operational sources.
•Build and optimize data models, views, stored procedures, and scripts in Microsoft SQL Server or similar platforms to support a scalable enterprise data warehouse.
•Implement and monitor automated ETL workflows, ensuring reliability, accuracy, and performance of scheduled data pipelines.
•Collaborate with business units to define data requirements and translate them into reliable, well-structured datasets for self-service reporting and analysis.
•Develop and maintain reporting and dashboard solutions using tools such as Power BI, SSRS, or Tableau.
•Participate in data governance efforts by documenting transformation logic, managing metadata, and ensuring data consistency and security across systems.
•Provide Tier 1 and Tier 2 technical support for core enterprise systems, focusing on data integrity, reporting alignment, and API/data integration troubleshooting.
•Assist in application upgrades and configurations with a focus on how changes impact data flows and reporting.
•Work closely with the Enterprise Application Manager to align data infrastructure with long-term business intelligence strategies.
Requirements
QUALIFICATION GUIDELINES
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Where applicable, an equivalent combination of education and experience may be considered in lieu of education/experience listed below.
Education/Experience
•Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field.
•Minimum of 5 years of hands-on experience with SQL development and ETL pipeline creation in a business intelligence or data engineering role.
•Strong proficiency in T-SQL and experience working with large, complex datasets in a relational database environment.
•Experience with ETL tools and frameworks (e.g., SSIS, Azure Data Factory, custom scripting).
•Familiarity with reporting/visualization tools such as Power BI, SSRS, or Tableau.
•Ability to troubleshoot data issues and communicate technical details clearly to non-technical stakeholders.
•Strong analytical skills and attention to data quality, performance, and maintainability. Preferred Qualifications
•Experience with Microsoft SQL Server, including performance tuning and job automation.
•Familiarity with Azure data tools, including Data Factory, Synapse, or Blob Storage.
•Knowledge of ERP platforms such as Tyler Munis or similar public sector systems.
•Understanding of public transit data structures (e.g., GTFS, NTD) and experience integrating data from operational and planning systems.
•Exposure to data governance frameworks, ITIL principles, or cybersecurity practices.
PHYSICAL ACTIVITIES
:
Physical activity includes, but is not limited to: on a continuous basis, sit at a desk for long periods of time; intermittently twist and reach office equipment; write or use keyboard to communicate through written means; lift moderate weight; reaching above the waist, reaching below the waist, and reaching waist to shoulder to reach inventory on shelves; repetitive motion and fingering when using a computer keyboard; talking and hearing when dealing with customers; and observation of transit projects and operations during field work along the right-of-way.