SSAS Tabular Model Developer
Do you have a passion for Data and Development? Want to work at someplace special? Do you love crafting unique solutions?
Centric Consulting is hiring SSAS Tabular Developers to our National team. Tabular Developers are the important link on projects, helping bridge the gap between different teams while also making sure the clients' business problems and needs are understood. Centric offers both a local model with minimal travel as well as a National travel model. This role would involve regular travel (typically within the US).
This is a mid-level full-time opportunity.
The Tabular Model Developer is responsible for creating advanced data models to support data visualizations in Microsoft Power BI and other tools. Performance tuning and working with large sets of data will set you apart. You will partner with a Business Analytics Designer and BI Developer to ensure high-quality visualization solutions.
What You Will Do
Coordinate technical design sessions with the Business Analytics Designer and BI Developer
Assess the data needs of visualizations and create a flexible model that produces quick results for large groups of reports and dashboards
Utilize your experience with Microsoft SSAS tabular model 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 all solutions with large data sets or when data volatility precludes a standard processing strategy
Optimize Power Pivot solutions so they can be properly rendered and used in Power BI
Replace existing MDX solutions with new tabular models using DAX
Create new tabular models based on newly created Data Warehouses and Data Lakes
Understand and implement complex user authentication and data access authorization security models in Analysis Services tabular model
Analyze data and identify data quality issues that can affect the model and reporting
Support and train other team members on Tabular methodology and the use of DAX
Participate in Code Reviews with Clients
Strong SQL skills
Strong DAX skills
Ability to review legacy Cube (MDX) Solutions and implement a replacement solution using DAX
Experience with Azure Data Service and Products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plus
Experience with Microsoft Power BI or other Visualization tools is a plus
Ability to integrate with Security protocols (SSO, Dual Factor)
Proven capacity of troubleshooting issues across multiple departments and vendors
Ability to adapt in a fast-paced flexible environment
Supportive environment We expect a lot from our SSAS Tabular Model Developers. But you won't be asked to do it alone. You will have the full support of the National Data and Analytics office leadership and everyone at Centric. We love to help people succeed.
Growth opportunities As a mid-size firm, there is more flexibility when it comes to career paths. Figure out what you want to do, and we'll figure out how to get you there.
Special culture Hands down, the people are the best part of Centric. But you shouldn't take our word on it check us out on Glassdoor, Facebook and Twitter to get a glimpse inside what makes us different.
Network of technology champions There's no fun in being the only geek in the room. Centric celebrates all things tech. For example, we hold a yearly gathering called Camp I/O. In the vein of TEDx talks, Camp I/O is an opportunity for technology-minded people across Centric to get together and show off what they can do when not constrained by client requirements and platforms.
Flexibility This is a full-time work-from-home position which means you are welcome to work wherever you wish be it Starbucks or your home office.
All-company (paid!) vacation trip Who doesn't want to go someplace warm in the winter?
Prefer to contract?
Contractor friendly environment Contractors are an important part of our Centric family and we treat them as such. You will find that our policies and practices make it easy for you to contract with us.
Benefits eligibility As a W2T temporary employee, you are eligible for Centric's W2T benefits package which includes medical and dental coverage. We are also open to Corp to Corp arrangements (no benefits in that case, however).
Full-time potential Many of our full-time employees originally started as contractors. If that's something you are interested in, we can explore those options. That said, if you want to remain a contractor that's fine too. We are flexible!
Centric believes the best solutions come from diverse teams. We strive to have an environment where everyone has an opportunity to be successful regardless of their race, color, religion, gender, national origin, ancestry, age, disability, military or veteran status, sexual orientation or gender identity.