Senior Data Engineer

JOB PURPOSE

The Senior Data Engineer is responsible for flow of information between systems, the quality of that data, and exposing that data to deliver information and insight.

The Senior Data Engineer oversees the data warehouse, ETL / ELT platforms, and other related systems and ensures connectivity to keep systems operating at full capacity as well as developing solutions to deliver relevant data to systems and customers in a timely and secure manner.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Facilitate the flow of information for students and staff between enrollment systems, student information systems, education applications, business systems, and other systems as needed
• Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions
• Lead in architecture and design of data warehouse and availability environment
• Lead in designing, building, and maintaining robust, scalable, and efficient data pipelines and architectures using platforms such as Azure Data Factory, Azure Databricks, Celigo, etc.
• Securely expose relevant data for efficient data analysis, reporting, dashboards, and business intelligence initiatives
• Develop and optimize queries and reports using SQL-based tools and technologies
• Perform data ingestion, transformation, and other ETL / ELT functions as needed
• Act as liaison between vendors and customers
• Troubleshoot and resolve issues related to data pipelines, data warehousing, reporting and analytics, business intelligence, data flows and integrations, etc.
• Mentor and provide technical guidance to junior team members
• Participate in business system planning, evaluations, and recommendations to improve service
• Inform stakeholders of potential issues, solutions, and potential improvements
• Provide insight into data integrity and cleanliness
• Facilitate continuous improvement cycle through solution improvements, including product updates, plug-ins, configuration changes, and migration to other platforms as appropriate
• Maintain documentation of procedures, processes, configurations, and contacts
• Develop, establish, and follow necessary access controls and disaster prevention / recovery methods

MAY PERFORM OTHER DUTIES AS ASSIGNED

DISCLAIMER

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of personnel so classified.

SKILLS AND KNOWLEDGE

• Demonstrates excellent oral, written, and interpersonal skill
• Ability to work independently with general guidance on outcomes and objectives
• Demonstrates ability to lead people and get results through others
• Thinks ahead and plans over a 1 2-year time span
• Ability to organize and manage multiple priorities
• Ability to communicate in a timely and professional manner
• Effective documentation and reporting skills
• Ability to communicate ideas in both technical and user-friendly language
• Strong customer service orientation

JOB REQUIREMENTS

• Bachelor's Degree from an accredited institution or equivalent combination of education and experience
• Proven experience as a Data Engineer or in a similar role
• 4-7 years of experience with data pipeline platforms such as Azure Data Factory, Azure DataBricks, Celigo, etc.
• 4-7 years of experience with SQL language and relational databases
• Experience with unstructured and non-relational databases
• 4-7 years of DBA experience, including data architecture, design, and optimization
• Experience with code-based languages and tools such as Python, Spark, PySpark, etc. for efficient data processing
• Experience working with APIs for data extraction and transmission
• Experience in database / application connectivity
• Strong knowledge of common statistics required
• May require travel both inside and outside of state
• May require need for occasional weekend or evening travel

WORK ENVIRONMENT

While performing the responsibilities of this position, the work environment characteristics listed below are representative of the environment the employee will encounter :

Usual office working conditions

PHYSICAL DEMANDS

• No physical exertion required.
• Travel within or outside of state.
• Light work : Exerting up to 20 pounds of force occasionally, and / or up to 10 pounds of force as frequently as needed to move objects.

TERMS OF EMPLOYMENT

Salary and benefits shall be paid consistent with CSUSA salary and benefit policy. Length of the work year and hours of employment shall be those established by Charter Schools USA.

FLSA OVERTIME CATEGORY

Job is exempt from the minimum wage and overtime provisions of the Fair Labor Standards Act.

EVALUATION

Performance will be evaluated in accordance with Charter Schools USA's policy.

DECLARATION

The Charter Schools USA Human Resources Department retains the sole right and discretion to make changes to this job description.

Any employee making changes unauthorized by Human Resources Department will be subject to disciplinary action up to and including termination.