The Governor's Office of Information Technology is committed to improving the lives of all Coloradans through innovation and collaboration. They are seeking a Principal Data Operations Engineer who will be responsible for implementing designs and standards, providing operational support, and collaborating across departments to enhance data operations.
Responsibilities:
- Implementing the designs and standards provided by the Data and Integrations Architect
- Providing platform and application administration, configuration management, end user management, security and application level patching and upgrades as well as source code control, deployment and release management; and providing support services as needed
- Providing operational support ranging from minor bug fixes to major enhancements and participate in planning for application replacement and modernization
- Consulting with Data and Integrations Architects, Principal Developers and other Data Operations and OIT team members, as appropriate to maintain and enhance existing platforms in line with OIT strategies (e.g., API Led Connectivity, Cloud First, Mobile First, Secure Colorado, etc.)
- Performing platform administration and support for applications within the data Operations
- Working with Data Architects, Data Engineers and Integration Developers on data ingestion, data transformation and data presentation tasks and scripts, including automation of these tasks
- Establish automation of manual processes, including code deployment and environment provisioning
- Acting as Tier-2 escalation point for on-call/break-fix efforts, to diagnose and resolve incidents and problems with platforms and applications within Data Operations portfolio
- Working with SecOps resources to ensure network security policy is established in a consistent, repeatable and automated manner
- Collaborating with Business Analysts, Customers, Project Managers, and others as appropriate to assist in the creation of estimates and timelines
- Performing coding (in-house applications) or configuration management (COTS applications) in accordance with standards and best practices and further minimize defects through disciplined unit testing
- Coordinating update releases and other system changes, contribute to the implementation of break/fix solutions, and update documentation and configuration information related to changes as needed throughout the life cycle
- Organizing, build, and validate all segments of the code and configurations related to a specific build (release) through CI/CD pipelines
- Ensuring application maintenance and configuration activities are consistent with established service portfolio policies, procedures, standards and guidelines
- Identifying and recommending changes to application and platform policies, processes, templates and standard operating procedures to improve the overall quality of services being delivered
Requirements:
- A minimum of seven (7) years of experience as a data engineer, DevOps Engineer, or similar software engineering role
- A minimum of one year (1) of experience designing, building, implementing, and maintaining data and system integrations using dimensional data modeling and development and optimization of ETL pipelines
- Experience with MS Azure DevOps CI / CD, Terraform and Python
- Subject Matter Domain Expertise on the platforms (applications) used for the execution of the State Strategy for Data Sharing and Integrations premised on API led connectivity: Snowflake - enterprise level data lake and data warehouse
- Subject Matter Domain Expertise on the platforms (applications) used for the execution of the State Strategy for Data Sharing and Integrations premised on API led connectivity: Informatica - enterprise level data catalog, data quality, data governance and data lineage management
- Subject Matter Domain Expertise on the platforms (applications) used for the execution of the State Strategy for Data Sharing and Integrations premised on API led connectivity: Tableau – an enterprise level platform used to support data analysis and data visualization needs of the business and technology teams that OIT supports
- Experience with columnar and relational database technologies such as MS SQL, PostgreSQL, MySQL, or others desired
- Familiarity with Continuous Integration and Continuous Delivery (CI/CD) pipelines
- Experience using Azure DevOps
- Familiarity with source code management tools such as TFS or Git
- Experience in design, build, and maintain robust ETL pipelines to ingest disparate data from diverse agency platforms, including legacy mainframes, relational databases, web APIs and flat-file storage into data warehouse
- Experience in maintaining rigorous compliance with PHI, PII, and HIPAA standards, as well as state-level data-sharing protocols
- Well versed in working with large, complex, inflexible datasets
- Experienced in healthcare data standards such as Medicaid/CHIP data, eligibility systems, claims data