Job ID: MT-DPHHS-TierTwo-2025-0591EH (90090328)
Remote/Local Data Engineer (15+) with PowerBI/Tableau, Data Modeling and BI experience
Location: Remote, MT (DPHHS)
Duration: 10 Months
Knowledge, Skills, and Abilities:
Primary Duties or Responsibilities as related to the ECIDS project:
Manages data collection, management, and storage for this project. Enhances and maximizes the quality, integrity, reliability, and access to data assets.
Builds data pipelines to bring together information from different source systems and creates the infrastructure for optimal extraction, transformation, and data loading from multiple sources.
Where applicable, enable data sharing and interoperable data exchange for the Division, the Department, other state agencies, and external partners/providers.
Oversees all stages of data onboarding, transformation, and enablement.
Assembles complex data sets that meet non-functional and functional business requirements.
Collaborates with associated programs to collect, prepare, organize, and secure the department’s data assets. Implements and enforces data privacy policies to comply with regulations.
Provides data models and engages in data modeling efforts as needed.
Delivers high-quality, uniform data to support analytics. Improves and streamlines access to data to drive innovation and outcomes.
Prepares data for analytical and operational uses. Integrates, consolidates, and cleanses data and structures it for analytics applications.
Enhances and maximizes the quality, integrity, and reliability of data assets. Expands the effective utilization of data through improved usability and accessibility of IT systems.
Enables data sharing and access across the department. Seeks opportunities to eliminate data redundancies, improve data quality, and provide exceptional data services to the department.
Train Data Management Office staff on management of the ECIDS solution
Train Division Staff on access and use of the system.
Experience Requirements:
1.7+ years’ experience in data engineering and analytics, computer science, information technology, or related fields. A minimum bachelor’s degree in data sciences is desirable, and a Master’s Degree in a Data Science field is preferred. Combinations of experience and education will be considered on a case-by-case basis.
2.5+ years of experience building Snowflake data warehouse solutions incorporating multiple source system data
3.5+ Years integrating reporting solutions, specifically Thoughtspot, PowerBI, and/or Tableau. Other BI solutions experience will be considered.
4.5+ years of Data Modeling experience
5.Significant experience producing deliverables on a regular cadence, as well as reporting on status to stakeholders
Demonstrated ability to communicate effectively to diverse audiences with varying levels of technical understanding.
Job/Project Description:
This Data Engineer position works primarily with the Early Childhood and Family Support Division (ECFSD) Early Childhood Integrated Data System (ECIDS) effort to build a centralized data system/warehouse for unifying data in the division. This position works closely with Division stakeholders to identify data requirements, onboard and transform data, confirm data quality and accessibility, and troubleshoot data-related technical issues. The Data Engineer streamlines data workflows, enhances data infrastructures for greater scalability and collaboration, and identifies opportunities to optimize delivery by developing, maintaining, and testing infrastructure for data generation. The Data Engineer contributes to the management of all data assets, a data lake, and serves to help deliver modernized reporting and Business Intelligence solutions.