Data Engineer-Remote

We offer an extensive benefits package, including a matching 401(k), after 30 days of full-time employment, and 2 weeks of PTO after 90 days, to take within this year!

Position Overview

• Support the analytical function by providing expertise on the backend processes having to do with data management and ETL
• Build/Monitor/Troubleshoot Extract, Transform and Load (ETL) nightly jobs
• Leverage broad experience and technical knowledge to propose solutions to complex business problems
• Drive efficiencies including process automation which lead to tangible ROIs on projects completed

Key Responsibilities

1. Review, Analyze, and Evaluate Business Systems and User Needs
   • Work with stakeholders to identify information needs and develop reports and/or dashboards
   • Enhance data warehouse through the exploration and integration of external and internal sources
   • Identify gaps in data availability, and implement solutions to close the gaps
   • Identify technology solutions that support business strategies and organizational goals
   • Continuously work to improve data management systems and processes
2. Set Standards
   • Work with the analysis team and other developers to provide efficient solutions for accessing data on demand
   • Document key decisions, processes, and issues related to business systems and reporting
   • Identify methodologies to enhance data retention practices

1. Design and Create Infrastructure
   • Design, implement, and maintain automated and integrated methodologies for efficient analysis and reporting
   • Works with leadership and other stakeholders to produce and validate easy access to data
   • Serve as a resource to analytics, IT, and other stakeholders in answering questions and resolving issues related to workflow

• Recommend and implement changes that can create efficiencies and streamline processes

Experience Required

Minimum:

• Bachelor's Degree or equivalent work experience
• 3 years of experience in data management and ETL
• 2+ Years of experience with Microsoft SQL Server.
• 2+ Years of experience with ETL Tools like SSIS, Azure Data Factory
• 2+ Years of experience with cloud platforms, preferably Microsoft Azure and Google Cloud
• Proficient in database languages (SQL)
• Proficient in Python

Preferred:

• 5 years of experience in data management, business analysis, or similar field
• Experience working with and managing large data sets
• Direct experience with SSIS and Azure Datafactory

Knowledge, Skills, and Abilities

• Strong ability to analyze user requirements and create backend BI solutions
• Exceptional interpersonal skills and relationship-building skills to work effectively with internal and external stakeholders
• Knowledge of and ability to understand and resolve data inconsistencies or variances
• Excellent writing skills for documenting user requirements
• Ability to communicate complex information in a meaningful way
• Ability to interact with managers to raise issues, discuss changes, and provide information
• Ability to work on multiple projects simultaneously in a collaborative environment
• Ability to prioritize and quickly resolve issues

Applicants must be authorized to work for any employer in the U.S. This job posting does not qualify to sponsor or take over sponsorship of an employment Visa for those who do not meet the work authorization requirements for employment in the U.S.

Ancora Education is committed to creating a diverse and inclusive work environment. We are an equal-opportunity employer that maintains a policy of nondiscrimination with respect to all employees and applicants for employment. All employment decisions are made without regard to an individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law.