Senior Data Engineer

Position Title:
Senior Data Engineer
Salary Range:
$73,806.20 - $126,582.07
Job Description Summary:
This position is responsible for participating in, and at times leading, the design, development, and maintenance of data solutions that align with organizational needs.
Job Description:
Essential Duties and Responsibilities

1. Design and development

• 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 with others 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 medium and large-scale systems.
• Stay informed and educated on changing technologies, frameworks, design approaches, and Data Engineering best practices.
• Participate in 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).

1. 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.

1. Participates in releases and support as necessary, including outside of traditional work hours.
2. Other duties as assigned
   Additional Job Description:

Required Qualifications

• Bachelor’s degree in computer science or related field AND a minimum of four (4) years of experience in designing and developing data solutions and managing 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 large scale databases equivalent to a total of eight (8) years.
• Four (4) years of 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.)
• Four (4) years of experience designing, developing, and maintaining ETL solutions (e.g. SSIS, Azure Data Factory).
• Two (2) years of experience with some of the following technologies: .NET, C#, REST, OAuth and ODBC.
• One (1) year experience with some of the following technologies: Azure, Power BI, SSRS, Azure DevOps, Jira, and Git.
• Business process/operational knowledge (e.g., customer service, inventory management, procurement, accounting, education/student data, etc.).

Minimum requirements for the Principal Data Engineer position:

• Bachelor’s degree in computer science or related field AND a minimum of ten (10) 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 fourteen (14) years.
• Ten (10) 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.)
• Ten (10) years’ experience designing, developing, and maintaining ETL solutions (e.g. SSIS, Azure Data Factory)
• Five (5) 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

• Bachelor’s degree in computer science or related field AND eight (8) years of experience in Data Engineering.
• Six (6) years of 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.).
• Six (6) years of experience designing, developing, and maintaining ETL solutions. (e.g. SSIS, Azure Data Factory)
• Four (4) years of experience with some of the following technologies: .NET, C#, REST, OAuth, and ODBC.
• Three (3) years of experience with some of the following technologies: Azure, Power BI, SSRS, Azure DevOps, Jira, and Git.
• One (1) year of experience with education/student data.

Positions open until filled.

Salary Range:

• Senior Data Engineer, Grade 10, $64,465.20 - $90,251.28, commensurate with experience.
• Principal Date Engineer, Grade 13, $90,415.78 - $126,582.07, commensurate with experience.

First review of applications will take place on April 1st. Please submit your applications prior to this date if you wish to be considered.

Location:

• This is a remote position, and is subject to Sourcewell’s telecommuting policies and procedures.
• On occasion may be expected to attend meetings or trainings at Sourcewell’s headquarters in Staples, MN, advance notice would be given to team member.

*Sourcewell is currently accepting applications from all states, except the following: California, Colorado, Connecticut, Illinois, Maryland, Massachusetts, New Hampshire, New Jersey, New York, Oregon, Rhode Island, Vermont, and Washington. Applicants living in or planning to relocate to a state not on this list are encouraged to apply. *
Sourcewell exists to empower community success. We stand with our partners in government and education striving to recognize and honor the differences in each of our community members. We are committed to removing barriers to equity.

Values

• Seek. Be curious.
• Empower. Be accountable and liberate others.
• Impact. Be a difference maker

Full Time/Part Time:
Full time
Position Type:
Regular
Scheduled Hours:
40#LI-Remot

Please refer the Job description for details