Senior Data Engineer - Oregon, United States - Sourcewell Technology

    Sourcewell Technology
    Sourcewell Technology Oregon, United States

    1 month ago

    Default job background
    Description

    Position Title:
    Senior Data Engineer


    Salary Range:
    $73, $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


    • 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).


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


    • Participates in releases and support as necessary, including outside of traditional work hours.
    • 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
    ANDa 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, $90,251.28, commensurate with experience.

    Principal Date Engineer , Grade 13, $90, $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-Remote

    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.
    About Us

    Our Core Purpose

    We are a self-sustaining organization that enriches lives in our five-county community.
    Our Vision

    Provide leading solutions that empower community success.

    #J-18808-Ljbffr