Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data and Analytics Engineer role.
Rezi rewrites your resume against Collectiv's job description. Free.
Tailor your resume to this Data and Analytics Engineer role.
Rezi rewrites your resume against Collectiv's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data and Analytics Engineer posting at Collectiv — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data and Analytics Engineer posting at Collectiv — free, in seconds.
About the Role
Collectiv's Data & Analytics Engineer is a versatile technical consultant combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities. This role bridges backend data platform work and front-end analytics, allowing a single consultant to manage a client's data journey from ingestion to insightful dashboards. You will design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build ELT/ETL pipelines, develop semantic models, and deliver Power BI reports, acting as a trusted technical advisor to enterprise clients. You translate ambiguous business requirements into scalable, well-documented technical solutions and are proficient in both Spark transformations and DAX formulas. This position is ideal for experienced professionals who excel in both Data Engineering and Senior Power BI Consulting.
Responsibilities
- Design and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory) and Databricks (Spark, Delta Lake, SQL Warehouses)
- Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices
- Develop scalable lakehouse architectures that support analytics, reporting, and downstream data products
- Translate business and analytical requirements into technical data models (star schemas, semantic models, 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 all data engineering workflows
- Design and implement complex data models utilizing Power BI, including enterprise-grade semantic layer development
- Create visually compelling, interactive reports and dashboards that drive measurable client decisions
- Develop, optimize, and peer-review DAX formulas for accuracy and performance at scale
- Integrate data from diverse sources into Power BI, leveraging SQL skills for efficient extraction and transformation
- Ensure data quality, reliability, and usability across the analytics platform
- Enable self-service analytics by partnering with client business teams to deliver trusted datasets and dashboards
- Work directly with client stakeholders to gather requirements, communicate technical concepts, and manage expectations
- Provide expert guidance on Power BI solutions and data platform decisions
- Conduct in-depth research on emerging tools and trends to keep clients ahead of the curve
- Act as a core technical asset in Collectiv’s marketing and business development efforts
- Facilitate training sessions and support client teams through platform adoption and change
- Build strong client relationships through clear communication, confidence with stakeholders, and a warm, personable presence
- Take a proactive approach to delivery and client relationships by anticipating needs, following through on commitments, and looking for opportunities to add value
- Collaborate with project managers, architects, and fellow consultants to align technical delivery with project goals
- Ensure solutions meet quality criteria related to performance, scalability, security, and maintainability
- Contribute to internal documentation, reusable patterns, and knowledge sharing across Collectiv
- Participate in post-project retrospectives and contribute to Collectiv’s data platform standards
Requirements
- Bachelor’s degree from an accredited university
- 5+ years of combined experience in data engineering, analytics engineering, and/or BI consulting
- Hands-on production experience with Microsoft Fabric and/or Databricks (both strongly preferred)
- Advanced proficiency in Power BI, including complex data modeling, DAX authoring, and performance optimization
- 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 (star schemas, semantic models, lakehouse patterns)
- Demonstrated ability to integrate data from diverse sources into both data platforms and BI tools
- Proven track record in a client-facing consulting role, working independently and managing stakeholder expectations
- Strong written and verbal communication style; data-filled, precise, and client-ready
- Experience migrating or modernizing legacy data warehouses to lakehouse architectures
- Experience integrating data platforms with downstream applications or external APIs
- Consulting experience spanning multiple clients, industries, or verticals
- Exposure to advanced analytics use cases: AI/ML model integration, predictive dashboards, or advanced statistical analysis
Skills
- Microsoft Fabric
- Databricks
- Spark
- Delta Lake
- SQL Warehouses
- Power BI
- DAX
- SQL
- ELT/ETL
- Data Modeling
- Lakehouse Architectures
- Version Control
- CI/CD
- Code Review
- API Integration
- AI/ML
- Predictive Dashboards
- Statistical Analysis
Location
- Remote
Work Type
- Fully Remote
- Full-time
Experience Level
- 5+ years of combined experience in data engineering, analytics engineering, and/or BI consulting
Education Level
- Bachelor's degree
Benefits
- Quarterly in-person team experiences
- Competitive compensation
- Clear growth trajectory
- Professional development opportunities
- Top-shelf benefits package
- Unlimited time off
- 100% covered health insurance (medical, dental, vision)
- 401(k) with a 4% match
- Educational assistance
- Tech stipend
- Discounts on various goods and services
About the Company
- Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning and AI with Power BI and the Microsoft Data Stack.
- Our mission at Collectiv is simple: We help enterprises make better decisions.
- Our Core Values: Growth Mindset, Excel with Humility, Communicate Actively and Empathetically, Work Hard, Play Hard, Keep Calm and Carry On.