Senior Data Analytics Architect

Plante & Moran, PLLC; Greenwood Village (CO); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health/Dental/Vision Insurance

Flexible Time Off

401(k) Plan

Discretionary Bonus

Travel/Lodging Reimbursement

Job summary

Plante Moran, PLLC is seeking a data engineering professional to architect and deploy client data environments, design and implement data warehouses, and develop ETL pipelines. You will work on API integrations, BI reports, and mentor junior staff, with opportunities to contribute to innovation projects.

The role requires 2+ years of data engineering experience, strong SQL and ETL skills, and familiarity with cloud platforms such as Fabric/Synapse/AWS Redshift/Snowflake/Databricks.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 2+ years of experience with data engineering and analytics deployment
• Diagnose and resolve complex technical challenges
• Manage multiple concurrent data development projects
• Hands-on experience SSIS, Azure Data Factory, Fabric or similar ETL technologies
• Cloud data platform experience (Fabric, Synapse, AWS Redshift, Snowflake, Databricks)
• Experience configuring, deploying, and/or administering a cloud data platform
• Experience with DevOps CI/CD tools and processes (ADO, GitHub, dbt)
• Strong SQL skills (stored procedures, CTEs, window functions, DDL/DML)
• Experience developing Python ETL scripts and APIs a plus
• Experience in manufacturing/construction industry a plus
• MS SQL Server / Azure / Fabric certifications a plus
• Experience developing BI reports

Responsibilities

• Gather requirements from client stakeholders
• Architect client data/analytics environments
• Design, develop, deploy data warehouses
• Perform advanced SQL scripting and data engineering
• Facilitate data modeling (conceptual/logical)
• Develop advanced ETL processes and data pipelines
• API integration, deployment, and support
• Develop/deploy BI reports and solutions
• Mentor and coach junior staff
• Participate in firm/client innovation projects
• Support practice development activities
• Support project management

Skills

SQL

Data engineering

ETL

Python

API integration

Mentoring

Project management

Education

Bachelor's degree in Computer Science / Information Systems

Tools

SSIS

Azure Data Factory

Fabric

Synapse

AWS Redshift

Snowflake

Databricks

ADO

GitHub

dbt

SQL Server

Job description

Plante Moran, PLLC is seeking a data engineering professional to architect and deploy client data environments, design and implement data warehouses, and develop ETL pipelines. You will work on API integrations, BI reports, and mentor junior staff, with opportunities to contribute to innovation projects.

The role requires 2+ years of data engineering experience, strong SQL and ETL skills, and familiarity with cloud platforms such as Fabric/Synapse/AWS Redshift/Snowflake/Databricks.