ETL-Data Warehouse Developer

Why the Texas Association of School Boards (TASB)

TASB comes from humble beginnings — picture a one-person organization created in 1949 to advocate for excellence in public education on behalf of Texas school board members. Fast forward to today, and we have over 500 employees working together to provide 1,024 school districts with purposeful resources and services so they can focus on what matters most — excellent education for over 5 million Texas students. 

Our employees work alongside talented team members who are passionate about supporting public education and enjoy learning from new and different perspectives.   TASB believes the rich variety of expertise our employees collectively bring to the workplace makes our organization highly successful. Our culture encourages employees to grow and become their best selves, professionally and personally, through a variety of innovative and collaborative development opportunities. You're likely beginning to see why we'd been regularly named by the Austin Business Journal as one of the Top Ten Best Places to Work 

TASB offers competitive pay, rich benefits (including retirement matching of 2:1 up to 5% after one year, which means that if you contribute 5% to the plan, TASB will contribute 10%), family-friendly paid leave, onsite daycare, onsite gym, wellness program, tuition reimbursement, hybrid work options, and more. 

Every role at TASB thoughtfully complements our mission and its impact on school districts across Texas. These roles include work in TASB's Risk Management Services division, which provides administrative services to the TASB Risk Management Fund – a multi-line self-insurance pool (or "risk pool") of Texas schools. If you consider your work exceptional, have a passion for insurance, risk management or risk pools, and want to help drive our mission forward, keep reading

About You 

As the RM ETL Developer, you will be an expert in designing, developing, implementing, and monitoring data pipelines and workflows. You will possess the skills to extract, transform, and load data from any source using a variety of scripting languages and tools. Your attention to detail will ensure all data pipelines and workflows produce accurate and reliable data. In addition, you will be heavily involved in the development of RMS's reporting environments and machine learning efforts.

A Typical Day 

• Work closely with the analytics team to gather requirements from stakeholders and end-users to develop and implement data integration, storage, reporting and analysis solutions to address business needs.
• Monitor operation and effectiveness of ETL and other data integration processes, data stores and tools, including troubleshooting and issue resolution.
• Work with cross-functional teams to optimize ETL jobs to ensure data accuracy, performance, and reliability.
• Work closely with the RM Data Engineer in the development of an innovative data warehouse solution, blending on-premises and cloud-based data models.
• Maintain a working knowledge of the functionalities and processes of source data systems used and accessed for data integration, storage, and reporting.
• If you're still reading, we'd love to meet you

How You'll Make an Impact

• Lead the development and testing of data warehouse codes, tools, structures, and processes, in coordination with the RM Data Engineer and RM Business Intelligence team to ensure accurate data integration between systems.
• Serve on cross-divisional teams including developers, systems analysts, and administrators to ensure timely, complete, accurate and reliable data to support operations, reporting, and business intelligence efforts.
• Participate in data integration and warehouse planning and modernization efforts.
• Participate in data governance initiatives and ensure data integration efforts conform to enterprise data governance and other standards.

Skills for Success

Education and Experience: 

• Bachelor's degree in information systems, computer science, mathematics, business, or related field, or equivalent experience and technical education. 
• Two to four years of experience as a database programmer, ETL developer, application developer or similar position. 

Knowledge, Skills, and Abilities:

• Ability to create code and execute complex data integrations using standard procedures, tools, and best practices. 
• Advanced coding and development skills using common database platforms and concepts.
• Ability to plan and prioritize work and collaborate across teams.
• Ability to communicate effectively, in both written and oral formats, with internal and external customers.
• Strong analytical and problem-solving skills. 
• Ability to learn and apply new technical skills as knowledge as demanded by new technical requirements or initiatives. 
• Knowledge and understanding of relational databases and data query techniques. 
• Ability to understand and translate system data and business rules into computer code.