Principal Data Engineer

Position Title:

Salary Range:

Job Description Summary:

Essential Duties and Responsibilities

1. Design and development

• Lead, design, and develop new data solutions and enhance existing data solutions that meet specified criteria.
• Create document designs (data structures, algorithms, constraints, dependencies, etc.) and review others designs to ensure accuracy and appropriateness of the solution.
• Collaborate with appropriate team members/stakeholders to identify business requirements and identify possible solutions.
• Document code created, testing, and deployment processes used.
• Design data and integration solutions for complex scenarios, working cross-functionally on large-scale systems.
• Stay informed and educated on changing technologies, frameworks, design approaches, and data engineering best practices.
• Lead data architecture planning and decision making.
• Develop and implement effective, secure, and efficient data solutions. (e.g. databases, integrations, reports, analytics, etc)
• Optimize systems for deliverability, scalability, and performance.
• Identify potential risks and issues that may occur within development and maintenance of data solutions, present potential options, and risk mitigation strategies.
• Develop quality control processes to ensure data integrity, including unit testing.
• Follow data solution development best practices, including compliance to internal and external regulations. (e.g. SOC, FERPA)

2. Support, maintenance, and continuous improvement

• Maintain existing critical data systems including updates, enhancements, and fixes.
• Collaborate with team members/stakeholders to ensure solutions are tested, secure, and monitored.
• Resolve errors within data systems.
• Respond to service desk tickets and requests from project managers or leadership.

3. Act as a mentor/lead/role model

• Serve as a mentor to other data engineers, supporting growth and development.
• Be an ambassador for data engineering lifecycle best practices, educating other data engineers, serving as a role model, and encouraging practices to follow.
• Provide guidance on complex issues, unique situations, and data engineering challenges.

4. Participates in releases and support as necessary, including outside of traditional work hours.

5. Other duties as assigned

Additional Job Description:

Required Qualifications

• Bachelor’s degree in computer science or related field AND a minimum of seven (7) years’ experience in designing and developing data solutions and managing large scale databases
  OR
• A combination of IT related post-secondary and/or professional education and demonstrated relevant work experience designing and developing data solutions and managing databases equivalent to a total of eleven (11) years.
• Five (5) years’ experience with SQL Server including: database design, writing and optimizing complex SQL statements and stored procedures, index design and maintenance, and database administration (e.g. security, backups, etc.)
• Five (5) years’ experience designing, developing, and maintaining ETL solutions (e.g. SSIS, Azure Data Factory)
• Four (4) years’ experience with some the following technologies: .NET, C#, REST, OAuth, and ODBC.
• Three (3) years’ experience with some the following technologies: Azure, Power BI, SSRS, Azure DevOps, Jira, and Git.
• Strong business process/operational knowledge (e.g., customer service, inventory management, procurement, accounting, education/student data, etc.)

Preferred Qualifications

• Master’s degree in computer science or related field AND fourteen years’ experience in data engineering.
• Twelve (12) years’ experience with SQL Server including: database design, writing and optimizing complex SQL statements and stored procedures, index design and maintenance, and database administration. (e.g. security, backups, etc.)
• Twelve (12) years’ experience designing, developing, and maintaining ETL solutions. (e.g. SSIS, Azure Data Factory)
• Seven (7) years’ experience with some the following technologies: .NET, C#, REST, OAuth, and ODBC.
• Five (5) years’ experience with some the following technologies: Azure, Power BI, SSRS, Azure DevOps, Jira, and Git.
• Three (3) years’ experience with education/student data.

Location:

• This is a remote position, and is subject to Sourcewell's telecommuting policies and procedures.
• On occasion, may be asked to travel to Staples, MN for meetings, professional development or team activities. Up to three to four (3-4) times per year. Notice will be given ahead of time.

Full Time/Part Time:

Position Type:

Scheduled Hours:

At Sourcewell, collaboration, respect, and belonging are the core of who we are. We believe in giving back to the community, offering paid volunteer time for staff, and supporting one another to do our best work. We’re proud to have been recognized by Top Workplaces, the nation’s leading employer recognition program, annually since 2016.

Our values:

Seek. Be curious.

Empower. Be accountable and liberate others.

Impact. Be a difference maker.