Senior ETL/BI Engineer - Snowflake & Databricks (Cross-Functional)

Artifintech; Lansing (MI); On-site; USD 90,000 - 130,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in Michigan is seeking a senior BI/ETL professional to bridge data warehouse development and analytics for government-related projects.

You will collaborate with data modelers and developers, design physical data models, and ensure data quality while working with Snowflake and Databricks. The role requires effective communication with multiple stakeholders and the ability to work independently.

Qualifications

• 6+ years building data warehouse BI apps including ETL, data marts, reporting, dashboards.
• Able to work cross-functionally between ETL and BI tasks.
• Experience with Snowflake and Databricks.
• 2+ years in Child Welfare Services, Juvenile Justice, or related field.
• Experience with State of Michigan PMM/SUITE/Agile methodology.
• End-user training experience.
• Ability to work independently with minimal directions.
• Strong communication with programmers, analysts, supervisors, and stakeholders.

Responsibilities

• Collaborate with data modelers and developers to refine logical designs into physical data models.
• Design applications with data reconciliation and performance considerations for reporting.
• Present information to Project Review Board and sponsors during reviews.
• Consult with agency clients to explain IT processes and projects and maintain communication plans.
• Provide project estimation and budgeting input to DTMB PMO managers.
• Serve as a team lead guiding code development and mentoring staff.
• Evaluate opportunities for tool and process standardization.
• Assist in disaster recovery planning and implementation.

Skills

Data Warehouse BI

ETL/Data Mart

Dashboards

Cross-functional collaboration

Communication skills

Education

Bachelor's degree or equivalent

Tools

Snowflake

Databricks

Job description

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in Michigan is seeking a senior BI/ETL professional to bridge data warehouse development and analytics for government-related projects.

You will collaborate with data modelers and developers, design physical data models, and ensure data quality while working with Snowflake and Databricks. The role requires effective communication with multiple stakeholders and the ability to work independently.