Data Engineer

Classification: Admin/Prof


Exemption Status/Test: Exempt


Job Grade: 5


Department: IT Solutions


Reports To: Department Director

Job Goal:


Design, build, and maintain scalable cloud-based data platforms, analytics pipelines, and business intelligence solutions that support escWorks, DevelopWorks (NextGen), and other Region 4 enterprise systems. This role partners closely with the Solution Architect to deliver trusted, high-quality dashboards, reports, and insights using AWS, Snowflake, Power BI, and related technologies.

Qualifications:
Education

• Bachelor's degree in a technical field such as Math, Engineering, Computer Science, or Information Technology

Experience:

1. 4+ years of experience in data analytics, data engineering, or business intelligence roles
2. Strong experience working in Agile environments and delivering work through sprint-based development
3. Hands-on experience building dashboards and reports using Power BI, AWS QuickSight, or similar tools
4. Advanced SQL experience across cloud data platforms (Snowflake, Redshift, Aurora, or equivalent)
5. Experience designing and maintaining cloud-based data pipelines using AWS services (Glue, Athena, Lambda, S3, DMS, etc.)
6. Experience supporting reporting and analytics for customer-facing or enterprise platforms
7. Experience migrating legacy reporting solutions (e.g., .NET, Crystal Reports, SSRS) to modern cloud BI platforms
8. Experience working with structured and semi-structured data
9. Experience using Python, R, or similar languages for data transformation and analysis
10. Strong understanding of data quality, data governance, and reporting best practices

Special Knowledge and Skills:

1. Strong ability to collaborate cross-functionally with engineering, product, customer engagement, and business stakeholders
2. Ability to manage work through Jira, including epics, stories, documentation, and delivery tracking
3. Excellent communication skills with the ability to translate technical concepts into business-friendly insights
4. Highly accountable, self-directed, and delivery-focused
5. Customer- and outcome-oriented mindset
6. Strong analytical, problem-solving, and documentation skills
7. Comfortable working in fast-paced, evolving environments

Preferred Qualifications

1. Experience in the education or public-sector environment
2. Experience supporting enterprise-scale platforms or multi-tenant systems
3. Experience with Snowflake data modeling and performance optimization
4. Familiarity with CI/CD, infrastructure-as-code, and DevOps practices for data platforms
5. Experience supporting AI/ML-enabled analytics or advanced reporting use cases

Major Responsibilities:

1. Partner closely with the Solution Architect and Product Teams to design and implement the data and analytics architecture for escWorks and NextGen platforms
2. Build and maintain scalable cloud data pipelines and curated datasets using AWS and Snowflake
3. Develop and support dashboards, reports, and analytics solutions using Power BI, AWS QuickSight, or equivalent tools
4. Gather and document reporting requirements from internal teams and external customers
5. Ensure data accuracy, consistency, and reliability across platforms and reports
6. rt data migrations and modernization efforts from legacy systems to cloud-based solutions
7. Maintain clear documentation of data models, pipelines, and reporting logic
8. Participate actively in Agile ceremonies and contribute to sprint planning and delivery
9. Support production analytics systems and respond to data-related incidents or escalations
10. Continuously evaluate and adopt new technologies and best practices in data and analytics
11. Occasionally, work outside normal business hours to support deployments or critical issues

Supervisory Responsibilities:


None

Physical Demands/Environmental Factors/ Mental Demands:


Frequent use of standard office equipment; prolonged sitting; occasional bending/stooping, pushing/pulling, and twisting; repetitive hand motions (keyboarding and use of mouse); occasional light lifting and carrying (less than 15 pounds); may work prolonged and irregular hours; work with frequent interruptions; maintain emotional control under pressure.