Data and Analytics Engineer
About The Position
The Data and Analytics Engineer is a versatile technical consultant who combines data engineering expertise with Power BI and analytics delivery. The role bridges backend data platform work and front-end analytics, taking client solutions from raw data ingestion through to insight-ready dashboards. The engineer designs and implements lakehouse architectures using Microsoft Fabric and Databricks, builds ELT/ETL pipelines, develops semantic models, and delivers Power BI reports while advising enterprise clients. The role calls for translating ambiguous business requirements into scalable, well-documented solutions and working across Spark transformations and DAX development. This position sits at the intersection of Collectiv’s Data Engineering and Senior Power BI Consultant practices. It includes client consulting, technical delivery, collaboration across project teams, and contributions to internal standards, reusable patterns, documentation, marketing, and business development. Success includes earning clients’ trust as a technical advisor, delivering scalable and secure solutions, enabling business users with reliable analytics assets, and maintaining a minimum 75% utilization rate. Collectiv offers a fully remote work environment with quarterly in-person team experiences, competitive compensation, professional development opportunities, unlimited time off, and a benefits package that includes 100% covered health insurance for employees and their families, a 401(k) with a 4% match, educational assistance, a tech stipend, and discounts on various goods and services.
Requirements
- Bachelor’s degree from an accredited university.
- At least 5 years of combined experience in data engineering, analytics engineering, and/or BI consulting.
- Hands-on production experience with Microsoft Fabric and/or Databricks.
- Advanced Power BI proficiency, including complex data modeling, DAX authoring, and performance optimization.
- Experience with Power BI dataset modeling at enterprise scale and embedding/API scenarios.
- Strong SQL skills, including performance tuning and analytical query design.
- Experience designing analytics data models, including star schemas, semantic models, and lakehouse patterns.
- Demonstrated ability to integrate diverse data sources into data platforms and BI tools.
- Track record in a client-facing consulting role, working independently and managing stakeholder expectations.
- Strong written and verbal communication skills, with precise, client-ready communication.
Nice To Haves
- Experience migrating or modernizing legacy data warehouses to lakehouse architectures.
- Experience integrating data platforms with downstream applications or external APIs.
- Consulting experience across multiple clients, industries, or verticals.
- Relevant certifications such as Azure Solutions Architect, Azure Data Engineer, Microsoft Fabric DP-600/DP-700, or Databricks certifications.
- Exposure to advanced analytics use cases such as AI/ML model integration, predictive dashboards, or advanced statistical analysis.
- Experience with both Microsoft Fabric and Databricks.
Responsibilities
- Design and implement modern data platforms using Microsoft Fabric and Databricks.
- Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices.
- Develop scalable lakehouse architectures for analytics, reporting, and downstream data products.
- Translate business and analytical requirements into technical data models, including star schemas, semantic models, and lakehouse patterns.
- Write, optimize, and tune SQL and Spark-based transformations for large-scale analytical workloads.
- Apply version control, CI/CD concepts, and code review standards to data engineering workflows.
- Design and implement complex Power BI data models and enterprise-grade semantic layers.
- Create interactive reports and dashboards that support client decision-making.
- Develop, optimize, and peer-review DAX formulas for accuracy and performance.
- Integrate data from diverse sources into Power BI, using SQL for efficient extraction and transformation.
- Ensure data quality, reliability, and usability across the analytics platform.
- Partner with client business teams to enable self-service analytics through trusted datasets and dashboards.
- Gather requirements from client stakeholders, communicate technical concepts, and manage expectations.
- Advise clients on Power BI solutions and data platform decisions, ensuring precision in data discussions.
- Research emerging tools and trends and provide guidance to clients.
- Contribute technical expertise to Collectiv’s marketing and business development efforts.
- Facilitate training and support client teams through platform adoption and change.
- Build client relationships through clear communication, stakeholder confidence, and a personable approach; anticipate needs and follow through on commitments.
- Collaborate with project managers, architects, and consultants to align technical delivery with project goals.
- Ensure solutions meet performance, scalability, security, and maintainability criteria.
- Contribute to internal documentation, reusable patterns, and knowledge sharing.
- Participate in post-project retrospectives and contribute to data platform standards.
- Maintain a minimum 75% utilization rate while balancing client delivery, internal collaboration, and business priorities.
Benefits
- Unlimited time off.
- 100% covered medical, dental, and vision insurance for the employee and family.
- 401(k) with a 4% match.
- Educational assistance.
- Tech stipend.
- Discounts on various goods and services.
- Professional development opportunities.
- Quarterly in-person team experiences.
- Competitive compensation.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
