Senior Data Engineer (Remote - Option for Hybrid in MN)

Scholarship America; Saint Peter, Pittsboro (MN, NC); Hybrid; USD 94,000 - 118,000; Full time

Job summary

Join a forward-thinking organization dedicated to transforming lives through education. As a Senior Data Engineer, you will play a pivotal role in developing and maintaining data architecture and pipelines that empower stakeholders to access critical insights. This position offers the flexibility of remote work while being part of a mission-driven team focused on creating equitable pathways to education. You will leverage cutting-edge technologies and collaborate with diverse teams to drive innovation and ensure data quality. If you are passionate about making a difference and eager to contribute to a meaningful cause, this role is perfect for you.

Benefits

Medical Insurance

Dental Insurance

Vision Insurance

403(b) Retirement Fund with 3% Match

Flexible Spending Accounts

Paid Time Off

Educational Reimbursement

Short-term Disability

Long-term Disability

Paid Holidays

Qualifications

• 5+ years of experience in data engineering with strong SQL skills.
• Experience with data ingestion, transformation, and cleansing pipelines.
• Familiarity with data governance and quality standards.

Responsibilities

• Develop and maintain data architecture and pipelines.
• Collaborate with stakeholders to design data models.
• Ensure data quality and compliance with governance policies.

Skills

SQL

Python

Data Bricks

T-SQL

Apache Spark

Data Governance

Agile Methodology

Data Quality Analysis

Machine Learning

Collaboration

Education

Bachelor's Degree in a related field

Tools

Azure Data Factory

Databricks Notebooks

AWS RDS

Microsoft SQL Server

PostGres SQL

MongoDB

Microsoft Power BI

Job description

Are you passionate about making a difference? Would you like to spend your working hours changing lives and leaving the world better than it was? Do you want to help eliminate barriers to higher education for students in need? Consider joining the amazing team at Scholarship America, where we're hard at work creating brighter futures for students-and building the plans that will help us grow to do even more.

Senior Data Engineer

• Full time
• Remote or Option for Hybrid in Bloomington or St Peter, MN
• Internal/External Position Opening

The Senior Data Engineer develops and maintains the technical data architecture, pipelines, and infrastructure to enable business stakeholders to access and analyze the data they need. This role collects, transforms, and prepares data from a variety of sources then models that data into a data analytics and insights platform and helps drive organizational data standards and governance.

ESSENTIAL JOB FUNCTIONS:

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Accountable for the design, development, and administration of data analytics and insight tools, processes, and governance.
• Creates, maintains and documents the data ingestion, transformation, and cleansing pipelines that can process data on demand, on a schedule, or in real time.
• Collaborates with the business functions and analytics teams to design data models in the gold layer, incorporate new and modified data sources into the analytics platform, and define processes for managing these changes.
• Creates data artifacts as needed to meet the functional and non-functional requirements of stakeholders.
• Coordinates and enforces data standards among various business stakeholders, data stewards, implementation specialist and software engineers.
• Provides leadership in delivering data analytics and insights services to the organization.
• Assists with maintaining an enterprise data catalog allowing users to browse and access data based on their permissions.
• Manages the enforcement of data quality standards, data security, privacy, and data governance policies.
• Manages, administers and maintains the Master Data Management systems
• Assists in creating and maintaining technical documentation, including design specifications, data models, and user guides to facilitate knowledge sharing and maintainability of developed solutions.
• Stays updated on the latest trends and advancements in business intelligence, data technologies, and actively seeks opportunities to expand skills and knowledge in the field.
• Leverages new technologies to drive innovation.[SL1]
• Recommends internal improvements including redesigning infrastructure for greater scalability, cost optimization, and automating manual processes.
• Assist in the administration of the on-premises and cloud-based database systems.
• Participate in SQL code reviews from software engineer teams to enforce SQL coding standards
• Guide software engineers on performance tuning, query optimization and indexing.
• Works with data from a variety of database and data source types across on-premises infrastructure and across a variety of cloud environments such as AWS, Microsoft Azure and Atlassian.
• Monitors pipeline operations and remediates any failures that occur.
• After-hours support required on occasion.
• Travel required on occasion.

REQUIRED SKILLS AND EXPERIENCE:

• Experience with analytics services such as Azure Data Factory, Databricks Notebooks, Apache Spark, Synapse Analytics, or Redshift Spectrum.
• Work experience creating data ingestion, transformation, and cleansing pipelines using Data Bricks.
• Strong understanding of the Star and Snowflake schema models
• Able to collaborate effectively with both technical and non-technical staff.
• Bachelor's degree and 5+ years of technical/analytical experience, or equivalent experience in a data engineering role.
• Strong experience in SQL and T-SQL, Python, PySpark, Scala, Java, or other relevant coding skills.
• Experience performing quality analysis and validation of data artifacts with underlying data sources.
• Experience working with dimensional data models, document / NoSQL databases and relational databases such as Microsoft SQL Server, PostGres SQL, MySQL and MongoDB.
• Experience working with Azure Cosmos DB and AWS RDS
• Experience with performance optimization of complex queries and large datasets.
• Experience working with and maintaining lake house and medallion architectures.
• Experience implementing compliance measures for GDPR and CCPA.
• Demonstrated ability to work & communicate efficiently, effectively and cooperatively with others.
• Experience working in an Agile delivery model.
• Dedication to continuous improvement and continuous learning.

PREFERRED SKILLS AND EXPERIENCE:

• Certified Data Engineer from Databricks, Microsoft, or equivalent.
• Experience working with Microsoft Power BI, AWS QuickSight and Tableau
• Experience working with Microsoft Purview and Profisee
• Experience with Machine Learning and Artificial Intelligence deployment and operation.

Pay range - Exempt ($94,400 - $118,000 - $141,600)

Application deadline: May 11th, 2025 (by 11:00 pm CT) or until filled

At Scholarship America, our team members are motivated by our core values: Student Impact, Teamwork, Inclusion, and Curiosity. Our vision is to empower an America where those with the most need have the opportunity to thrive through equitable pathways to education and training and we are seeking fantastic team members to make that happen.

We know the best person for the job could be anywhere and that's why this position can work remotely within the continental United States or in a hybrid manner from either our office in Bloomington or Saint Peter, MN. Our employees enjoy a team-based, flexible work schedule, allowing them to flex around our core hours of Monday-Friday from 8:00 am - 4:30 pm Central Time. [SL2] Scholarship America is committed to our team's work/life balance and our strong learning and development culture supports knowledge growth and professional development for all employees across foundational and job-specific skills.

Scholarship America offers employees a robust total rewards package, focused on supporting their health and well-being now and in the future. We offer comprehensive choices for the following:

• Insurance (medical, dental, vision, basic life)
• Disability (short-term & long-term)
• Flexible spending accounts (medical & dependent care)
• 403(b) retirement fund with a 3% company match

In addition to schedule flexibility, we also provide paid time away from work (vacation, sick, personal, and up to fifteen paid holidays annually), plus employee & dependent educational reimbursement programs which support our overall mission.

Details on our company mission, vision, values, and goals can be found at www.scholarshipamerica.org.

We are an equal opportunity employer and believe in the power of a diverse workplace to better serve a broad range of student needs. All qualified candidates who meet the minimum requirements are encouraged to apply and will receive consideration for employment regardless of their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, parental or marital status.

With $5 billion in distributions to students since 1958, Scholarship America is the leading administrator of private scholarships in the United States.