What are the responsibilities and job description for the PowerBI Architect position at Centric Consulting?
PowerBI Architect
Job Location: United States, Remote
Join our team
Centric Consulting is an international management consulting firm with expertise in digital, business and technology. We are looking for a PowerBI Architect to join our growing Data & Analytics team.
What We Offer?
We offer benefits to support your physical, emotional, mental and financial health:
- Time Off, When You Need It. A self-managed paid time off (PTO) program.
- Built For Families. Parental leave and flexible remote working options.
- Care For You and Yours. Flexible health care options for you, your family and your pets. Plus, long-term disability, 401(k) benefits and more!
- Help With the Little Things. Stipends to offset home office costs (such as internet, cell service and supplies).
- Our Success Is Your Success. A profit-sharing program and annual company-sponsored trip to celebrate our accomplishments together.
- Opportunities to Grow. Take courses. Attend conferences. Get certified.
Want to know why you should work with us and what we offer employees? Visit our website to learn more.
In this role, you will:
- Coordinate technical design sessions with the Business Analysts and BI Developer
- Assess the data needs of an organization and create a flexible enterprise model that produces quick results for large groups of reports and dashboards for various departments
- Utilize your experience designing tabular models by writing complex DAX scripts to support Power BI KPIs
- Review the visualization use cases and determine whether the use of In-Memory models or Direct Query is needed
- Performance tune the tabular model to work with large data sets and/or complicated DAX formulas
- Build enterprise reporting capability using Analysis Services on-prem or in Azure
- Design the tabular model for consumption by non-technical business users in compliance with existing naming standards and metric calculations
- Optimize tabular models so they can be properly rendered in other BI Tools
- Replace existing BI solutions (e.g. MDX, Tableau, Cognos, QLIK) with new tabular models using DAX
- Create tabular models based on Data Warehouses and Data Lakes
- Understand and implement complex user authentication and data access security models in Analysis Services
- Analyze data and identify any data quality issues that can affect the model and reporting
- Support and train other team members on tabular model methodology and the use of DAX
- Participate in code reviews with Clients
Who you are:
3-5 years of experience in the following areas:
- Strong SQL and DAX skills
- Expertise designing semantic data models that express the business context
- Ability to architect and design a tabular model solution
- Experience with Microsoft Power BI is a plus
- Experience with Azure Data Service and products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plus
- Ability to integrate row-based security into tabular models
- Proven capacity of troubleshooting issues across multiple departments and vendors
- Ability to adapt in a fast-paced flexible environment
About Centric Consulting:
Founded in 1999 with a remote workforce, we combine the benefits of experience, flexibility and cost efficiency to create tailored solutions centered on what’s best for businesses. Now numbering more than 1,400 employees across the country and India, we’re committed to solving clients’ toughest problems and delivering on our mission of providing unmatched experiences.
Our purpose at Centric Consulting is to bring unmatched experiences to clients and employees. These aren't just words we use — it's how we became a company and who we are today. Providing an unmatched experience means we approach each other as human beings and lead with empathy and humility. It means we work diligently to ensure we are a place where everyone can create a sense of belonging and feel respected for who they are.
We know that creating and sustaining an authentically welcoming culture requires that we all play a part in promoting diversity, equity, and inclusion , from our business practice to how we show up for employees and communities. At Centric, we are looking for and embrace candidates of all backgrounds and identities who have a hunger for learning, collaborating, and generating unmatched experiences. This is how we bring our mission and core values to life, working together to provide the highest quality services to our clients while allowing our employees to reach their full potential.
#LI-Remote
