Data Engineer I

Summary of Purpose:

The data engineer I is responsible for designing, building, and maintaining a company's data infrastructure, including databases and data pipelines, to ensure accurate and timely data access for analysis by collecting, processing, and transforming raw data into usable formats for other stakeholders within an organization; requiring strong programming skills in languages like Python and SQL, expertise in data modeling, and knowledge of cloud computing platforms to manage real time data effectively
 
Responsibilities will include hands-on implementation and development of ETL, API, streaming, and other integration tools running on-prem or cloud. The services built by the data engineer I will enable web applications, mobile applications and integration with 3rd party systems. This role will also design how features should be implemented and help determine the best architecture to use in each situation.

Essential Functions

• Designs, implements, and optimizes data pipelines to ingest, process, and transform large volumes of structured and unstructured data from various sources
• Develops robust Extract, Transform, Load (ETL) processes to integrate data from diverse sources into the data ecosystem
• Creates data models to structure and organize data within databases and data warehouses, ensuring efficient data access and analysis
• Implements data quality checks and monitoring mechanisms to identify and address data inconsistencies
• Works closely with internal IT stakeholders and business users to understand data requirements and deliver actionable insights
• Performs other duties as assigned

Knowledge, Skills, and Abilities

• Demonstrates strong knowledge of relevant specialty area, leading important initiatives, offering guidance to team members, and promoting innovation and strategic improvements within the organization
• Advanced ability to communicate complex information in a clear and understandable manner to stakeholders
• Ability to lead diverse teams to achieve common goals, while mentoring team members
• Demonstrates advanced planning, organizational, and time management skills, leading multiple projects, guiding team members, and driving strategic initiatives to achieve organizational goals
• Strong ability to conduct research, gather information, and stay current with industry trends and best practices to influence change within relevant specialty area
• Advanced ability to analyze data, trends, and complex problems to problem solve within relevant specialty area
• Exemplifies a strong ability to seek out and learn from feedback, coaching, and new experiences. Proactively adapts to new challenges and leverages learnings to drive innovation and mentor others
• Demonstrated ability to facilitate collaboration across various departments to harness collective creativity and drive innovative solutions. Utilize strong communication skills to effectively convey ideas and lead discussions. Demonstrated impact in cross-functional projects, ensuring alignment and synergy among diverse teams
• Ability to work and maintain confidentiality of highly sensitive/private information
• Understanding of data governance best practices to ensure data quality and compliance
• Proficiency in programming languages such as Python, SQL, and potentially other languages like .Net, C#, etc.
• Experience with data warehouse solutions like Azure Synapse and others
• Understanding of data modeling concepts such as dimensional modeling or star schema
• Proficiency with data integration tools to combine data from disparate sources
• Prior experience with cloud services such as Azure

Education, Licenses, and Certifications

Required

• High School Diploma or GED

Preferred

• Bachelor’s degree with major coursework in computer science, information systems, or a closely related field or commensurate studies and experience

Experience

Required

• Four or more years of professional work experience
• Two or more years of experience in building software applications, producing successful architecture and design solutions to complex problems
• Two or more years building REST webservices, SOAP API, Graph API etc.
• Two or more years Agile/Scrum software development experience
• Two or more years of experience working on web application development with front end technology platforms like Angular, ASP.net, or any other JavaScript technology

Preferred

• Five or more years of experience in building software applications.
• Five years of experience developing enterprise software web-based applications and services
• Four or more years Agile/Scrum software development experience
• Four or more years of experience working on web application development with front end technology platforms like Angular, ASP.net, or any other JavaScript technology.
• Five or more years of Full-stack coding experience with C#, Typescript, JavaScript or similar programming languages. Experience with front end frameworks like Angular, Blazor etc.
• Two or more years of experience with architecture patterns like MVC, Microservices etc.
• At least one year of experience as a technical team lead and conducting research on different products and recommending the product based on the organization fit.

Additional Requirements

Work Context

• Must be able to work prolonged periods of sitting at a desk and working on a computer
• Must be able to work under minimal supervision
• Must be able to sit, stand, walk, stoop, kneel, crouch, climb, and crawl
• Must be able to lift 25 pounds
• Must have a US state or territory issued Real ID compliant driver’s license or identification card

Behaviors and Assessments

• All INPO employees are expected to abide by behavioral expectations as outlined in INPO’s Core Values, Team Effectiveness Attributes, and Leadership Effectiveness Attributes
• Employment is dependent upon successfully completing a pre-employment background check and drug and alcohol test
• This position may require obtaining unescorted access status
• This position requires direct or indirect access to certain export-controlled technology, for which INPO may be required to obtain an export license in accordance with applicable U.S. export control laws and regulations.  If an export license is required, any offer of employment at INPO for this position is contingent upon receipt of the export license or authorization