Amplytics is seeking a Data Analytics Consultant to drive complex data analysis projects for our clients. In this role, you will manage complex data analysis projects using Microsoft Power BI. This role requires both technical excellence and strong business acumen to deliver impactful insights that drive client success.
Key Responsibilities:
Design and implement end-to-end Power BI solutions tailored to specific business requirements
Develop complex data models using DAX to solve sophisticated business problems
Create intuitive, interactive dashboards that effectively communicate key business insights
Implement efficient ETL processes using Power Query for data preparation and transformation
Optimize performance of Power BI reports and data models for enterprise-scale solutions
Consult with stakeholders to gather requirements and translate business needs into technical specifications
Provide technical guidance and troubleshooting for existing Power BI implementations
Train client teams on Power BI and DAX fundamentals to ensure knowledge transfer
Implement data governance and security protocols within Power BI environments
Establish reporting frameworks and best practices for sustainable analytics
Document technical specifications and create user guides for implemented solutions
Stay current with Power BI updates and incorporate new features into client solutions
Technical Skills
Power BI & DAX Expertise
Advanced knowledge of Power BI Desktop, Service, and Mobile applications
DAX formula mastery for complex calculations and time intelligence functions
Star schema and dimensional modeling for optimized data structures
Power Query (M language) for advanced data transformations
Implementation of row-level security and proper governance protocols
Additional Technical Skills
SQL for data extraction and manipulation
Tabular modeling in Analysis Services (SSAS)
Experience with DirectQuery and Composite models
Knowledge of Power BI REST API for automation
Qualifications
Bachelor's degree in related field (Computer Science, Information Systems, etc.)
3+ years of experience with Microsoft Power BI development
Advanced knowledge of DAX and data modeling
Microsoft Power BI certifications preferred
Proven track record of successful implementations
Amplytics is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. We believe in fostering an inclusive workplace where differences are celebrated, and all employees can truly be themselves. Our diversity fuels our innovation and connects us closer to our customers and the communities we serve.