Data Engineer

Classification: Admin/ProfExemption Status/Test: ExemptJob Grade: 5Department: IT SolutionsReports To: Department DirectorJob 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:EducationBachelor’s degree in a technical field such as Math, Engineering, Computer Science, or Information TechnologyExperience:4+ years of experience in data analytics, data engineering, or business intelligence rolesStrong experience working in Agile environments and delivering work through sprint-based developmentHands-on experience building dashboards and reports using Power BI, AWS QuickSight, or similar toolsAdvanced SQL experience across cloud data platforms (Snowflake, Redshift, Aurora, or equivalent)Experience designing and maintaining cloud-based data pipelines using AWS services (Glue, Athena, Lambda, S3, DMS, etc.)Experience supporting reporting and analytics for customer-facing or enterprise platformsExperience migrating legacy reporting solutions (e.g., .NET, Crystal Reports, SSRS) to modern cloud BI platformsExperience working with structured and semi-structured dataExperience using Python, R, or similar languages for data transformation and analysisStrong understanding of data quality, data governance, and reporting best practicesSpecial Knowledge and Skills:Strong ability to collaborate cross-functionally with engineering, product, customer engagement, and business stakeholdersAbility to manage work through Jira, including epics, stories, documentation, and delivery trackingExcellent communication skills with the ability to translate technical concepts into business-friendly insightsHighly accountable, self-directed, and delivery-focusedCustomer- and outcome-oriented mindsetStrong analytical, problem-solving, and documentation skillsComfortable working in fast-paced, evolving environmentsPreferred QualificationsExperience in the education or public-sector environmentExperience supporting enterprise-scale platforms or multi-tenant systemsExperience with Snowflake data modeling and performance optimizationFamiliarity with CI/CD, infrastructure-as-code, and DevOps practices for data platformsExperience supporting AI/ML-enabled analytics or advanced reporting use casesMajor Responsibilities:Partner closely with the Solution Architect and Product Teams to design and implement the data and analytics architecture for escWorks and NextGen platformsBuild and maintain scalable cloud data pipelines and curated datasets using AWS and SnowflakeDevelop and support dashboards, reports, and analytics solutions using Power BI, AWS QuickSight, or equivalent toolsGather and document reporting requirements from internal teams and external customersEnsure data accuracy, consistency, and reliability across platforms and reportsrt data migrations and modernization efforts from legacy systems to cloud-based solutionsMaintain clear documentation of data models, pipelines, and reporting logicParticipate actively in Agile ceremonies and contribute to sprint planning and deliverySupport production analytics systems and respond to data-related incidents or escalationsContinuously evaluate and adopt new technologies and best practices in data and analyticsOccasionally, work outside normal business hours to support deployments or critical issuesSupervisory Responsibilities:NonePhysical 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.

• Bachelor’s degree in a technical field such as Math, Engineering, Computer Science, or Information Technology, * 4+ years of experience in data analytics, data engineering, or business intelligence roles
• Strong experience working in Agile environments and delivering work through sprint-based development
• Hands-on experience building dashboards and reports using Power BI, AWS QuickSight, or similar tools
• Advanced SQL experience across cloud data platforms (Snowflake, Redshift, Aurora, or equivalent)
• Experience designing and maintaining cloud-based data pipelines using AWS services (Glue, Athena, Lambda, S3, DMS, etc.)
• Experience supporting reporting and analytics for customer-facing or enterprise platforms
• Experience migrating legacy reporting solutions (e.g., .NET, Crystal Reports, SSRS) to modern cloud BI platforms
• Experience working with structured and semi-structured data
• Experience using Python, R, or similar languages for data transformation and analysis
• Strong understanding of data quality, data governance, and reporting best practices

Special Knowledge and Skills:

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

Preferred Qualifications

• Experience in the education or public-sector environment
• Experience supporting enterprise-scale platforms or multi-tenant systems
• Experience with Snowflake data modeling and performance optimization
• Familiarity with CI/CD, infrastructure-as-code, and DevOps practices for data platforms
• Experience supporting AI/ML-enabled analytics or advanced reporting use cases, 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.