Principal Data Engineer
About The Position
This position is responsible for leading in the design, development, and maintenance of data solutions that align with organizational needs. The role involves designing and developing new data solutions and enhancing existing ones, creating and reviewing design documents, collaborating with stakeholders to identify business requirements, and documenting code, testing, and deployment processes. The Principal Data Engineer will design data and integration solutions for complex scenarios, stay updated on changing technologies and best practices, lead data architecture planning, develop and implement effective, secure, and efficient data solutions, optimize systems for deliverability, scalability, and performance, identify and mitigate potential risks, and develop quality control processes including unit testing. The role also includes maintaining existing critical data systems, resolving errors, responding to service desk tickets, and acting as a mentor and role model for other data engineers, promoting best practices and providing guidance on complex issues. Participation in releases and support as necessary, including outside of traditional work hours, is also expected, along with other duties as assigned.
Requirements
- 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.)
Nice To Haves
- 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.
Responsibilities
- 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)
- 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.
- 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.
- Participates in releases and support as necessary, including outside of traditional work hours.
- Other duties as assigned
Benefits
- paid volunteer time
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Principal
