Senior Consultant - Data Engineering / Data Architect

About the role

Provides technical, architectural, and project leadership across complex, multi-phase digital and data-centric client engagements. Accountable for defining data and analytics architecture strategy, advising clients, leading delivery teams, and ensuring solutions align with client business objectives. Operates with minimal supervision and exercises independent judgment related to architecture decisions, delivery approach, risk management, and client engagement strategy.

Responsibilities

• Leads technical and architectural communication with clients and internal stakeholders, clearly articulating methodologies, rationale, trade-offs, and outcomes at both technical and executive levels.
• Independently defines and evaluates technical and architectural approaches for complex problems, engaging subject matter experts strategically while retaining accountability for solution design.
• Serves as a trusted advisor to clients on data governance, security, compliance, and operating models, aligned with enterprise and regulatory requirements.
• Defines target-state data architectures and leads delivery of scalable cloud-based data warehousing and analytics solutions aligned with long-term client strategies.
• Acts as the primary client interface for assigned engagements, translating business objectives into technical and architectural strategies, presenting recommendations to senior stakeholders, and guiding decision-making.
• Provides technical and professional mentorship to internal teams, contributes to practice standards and reusable assets, and demonstrates thought leadership in data architecture and engineering.

Requirements

• Master’s degree in data science or engineering
• 10+ years of progressively responsible experience in data architecture, data engineering, analytics, or digital consulting, including leadership of complex client engagements.
• Advanced proficiency in SQL and Python, with demonstrated ability to design, review, and guide complex data engineering solutions
• Expert-level knowledge of SQL, data modeling, and data warehousing concepts
• Deep experience designing and governing enterprise-scale ETL/ELT and data integration frameworks
• Experience with Microsoft Power Platform (Power BI, Power Apps, Power Automate)
• Experience leading cross-functional delivery teams and managing project financial performance in a consulting environment.
• Strong executive-level communication skills with experience presenting architecture, strategy, and recommendations to senior client stakeholders.

Qualifications

• Bachelor's Degree or relevant work experience.
• 4+ years experience in a business/consulting environment.

Skills

• SQL
• Python
• Cloud-native data platforms (Azure preferred; AWS/GCP acceptable)
• Microsoft Power Platform (Power BI, Power Apps, Power Automate)
• Data modeling
• Data warehousing
• ETL/ELT solutions
• Data governance
• Data security
• Client engagement
• Technical communication
• Project management

Benefits

• Medical
• Dental
• Vision
• Disability
• Wellness programs
• Paid vacation
• Holiday time
• Sick time
• Dependent sick time
• Tuition reimbursement
• Vendor discounts
• Performance-based bonus program

Pay

Salary Plan

Schedule

Hybrid or flexible work options may be offered after the first 90 days of employment based upon manager discretion, job performance, and work assignments.