Senior Data Engineer/Data Systems Engineer

Verified Job On Employer Career Site

Job Summary:

Ho-Chunk, Inc. is a Native American owned company seeking a Senior Data Engineer/Data Systems Engineer responsible for designing, developing, and maintaining advanced data architectures and processing systems for the National Park Service. The role involves overseeing the full data lifecycle, ensuring data quality and integrity, and collaborating with multidisciplinary teams to enhance decision-making and operational efficiency.

Responsibilities:

• Developing and maintaining data processing software responsible for requirement capture, database development, data documentation, and the development and maintenance of data processing pipelines.

• Coordinating with NPS staff to create unique data infrastructure.

• Running tests on designs to isolate errors and updating systems to accommodate changes in NPS needs.

• Developing data models, database schemas, data pipelines, and performing data migration activities.

• Migrating data from as-is to to-be data structures.

• Maintaining expertise in SQL and Python programming to write procedural code for databases including Microsoft SQL Server and PostgreSQL (T-SQL or PL/pgSQL code).

• Understanding enterprise-level spatial data management, its unique characteristics, and how to effectively store spatial data within RDBMS and geodatabases.

• Creating data migration plans, documenting key activities, tasks, and risks.

• Building required coding and/or infrastructure for optimal extraction, transformation, and loading (ETL) of data from various data sources using Cloud and SQL technologies.

• Performing analysis to assess quality and meaning of data; documenting data business and quality rules and implementing them.

• Designing quality management processes and planning for data migration activities, including validation of loaded data.

• Identifying, designing, and implementing internal process improvements, including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes.

• Working with stakeholders and customers, assisting them with data-related technical issues and data infrastructure needs.

• Working with NISC and other NPS staff to identify process improvement opportunities and propose system modifications; creating presentations and reports.

• Structuring small and large data sets appropriate to the intended audience or application to support efficient retrieval of usable information; performing data requests as needed.

• Defining and maintaining domain definition requirements for attributes/columns.

• Working with a team of analysts, database administrators, GIS specialists, and other personnel to process alphanumeric and geospatial information and support data governance activities.

• Developing and documenting appropriate metadata records for data management systems and data standards.

• Showcasing advanced expertise in developing and optimizing complex data pipelines and analytics solutions that significantly enhance decision-making capabilities and operational efficiency.

Qualifications:

Required:

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a closely related technical field is required; a Master’s degree is highly preferred.

• Minimum of 5 years of progressive experience in data engineering, data systems development, or a similar technical role, including designing and maintaining complex data architectures and pipelines.

• Extensive hands-on experience developing and optimizing data models, database schemas, and ETL/ELT processes in enterprise environments.

• Strong expertise in SQL and procedural database programming languages (e.g., T-SQL, PL/pgSQL), with demonstrated experience on platforms such as Microsoft SQL Server and PostgreSQL.

• Proven experience working with cloud-based data platforms and services (e.g., Microsoft Azure, AWS), including cloud-native data integration and storage solutions.

• Experience with large-scale data migrations, performance tuning, and supporting data governance and quality initiatives at the organizational level.

• Demonstrated ability to lead technical teams, mentor junior engineers, and provide strategic input on data architecture and system design.

• Senior level: Possesses and applies comprehensive knowledge across key tasks and high impact assignments.

• Plans and leads major technology assignments.

• Evaluates performance results and recommends major changes affecting project growth and success.

• Functions as a technical expert across multiple project assignments.

• May supervise others.

• Strong understanding and ability to plan and design modern databases and data structures, including geospatial.

• Strong analytical and time management skills.

• Experience with computer programming, distributed systems, database design and administration.

• Attention to detail.

• Excellent written and verbal communication skills.

• Self-motivated and able to handle tasks with minimal supervision or questions.

• Ability to deliver a high level of customer service.

• Understanding of data governance and stewardship processes and activities.

• Ability to develop, implement, deploy, and maintain data management solutions.

• Focus on continuous data quality improvement and innovative ways to leverage data.

• Effective communication skills to operate with others and communicate clearly.

• Ability to partner well within a collaborative, national, matrixed team environment.

• Eagerness to advocate for data management best practices.

• Proficiency in relevant tools and technologies for data analysis and engineering.

Company:

Ho-Chunk, Inc. is the award-winning economic development corporation owned by the Winnebago Tribe of Nebraska. Founded in 1994, the company is headquartered in Winnebago, Nebraska, USA, with a team of 1001-5000 employees. The company is currently Late Stage.