Department: Office of Organizational Performance

Reports To: Chief Information Officer

Location: Dallas, Texas – ABOG National Center; Hybrid Work environment with expectation for 40% in office.

FLSA Status: Exempt

Summary: The Senior Data Engineer will oversee the department's data integration work, including developing a data model, maintaining a data warehouse and analytics environment, and writing scripts for data integration and analysis. This role will work closely and collaboratively with members of the Scrum team and CIO to define requirements, mine and analyze data, integrate data from a variety of sources, and deploy high quality data pipelines in support of the Organization. They will also create and oversee an automated reporting system and manage other proprietary systems. 

Essential Duties and Responsibilities:

• Maintain and build on our data warehouse and analytics environment.
• Design, implement, test, deploy, and maintain stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics projects, including integrating new sources of data into our central data warehouse, and moving data out to applications and affiliates.
• Build reports and data visualizations, using data from the data warehouse and other sources.
• Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
• Perform ad hoc data integration and management, and analysis on a wide variety of data sources and projects.
• Implement and monitor best in practice security measures in our OLTP and OLAP databases.
• Help other IT staff troubleshoot and tune their SQL, Python, or R code.
• Mentor other members of the data team
• Other duties as assigned.

Skills and Qualifications:

• Demonstrable Proficiency: Candidates will be required to demonstrate proficiency in essential skills during the interview process.
• BS or BA in CS, CIS, MIS or related discipline.
• 7 years’ experience in relational databases and SQL. Extract, Transform, and Load (ETL) data into a relational database.
• 7 years’ experience in data transformation and manipulation.
• 7 years’ experience in delivering reports.
• Proficiency with Python or R preferred but not required.
• Use APIs or SSIS to push and pull data from various data systems and platforms.
• Experience with AI including but not limited to LLM, SLM, ML.
• Experience working with cloud infrastructure services like Amazon Web Services and Microsoft Azure preferred.
• Experience with advanced data visualization and mapping are helpful, but not required.
• Experience is a SAAS or deployed software environment preferred but not required.

PHYSICAL REQUIREMENTS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to sit; use hands to handle or feel and talk or hear. The employee is frequently required to reach with hands and arms. The employee is frequently required to reach with hands and arms. The employee is occasionally required to stand and walk. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

WORKING CONDITIONS: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job in a typical office or administrative setting. The noise level in the work environment is usually low.

COMPENSATION: Salary commensurate with experience. Excellent benefits program including Health, Dental, Vision, Health Savings Account, employer-matching 401(k), Basic Life and AD&D insurance, and Long-Term Disability.