BI And Analytics DeveloperBI and Analytics Developer Permanent Position Weston, MAAs a BI and analytics developer, you will collaborate with the Business Intelligence and Analytics group to deliver high-value data targets and opportunities to the customers. You'll work alongside architects to create and update data models, perform data transformations and make sure our BI environment is loaded and available to the business partners. Your strong SQL skills will ensure that transformations are fast and accurate, while your DAX skills will enable you to create needed measures and hierarchies.
With your ability to deliver against a variety of data access solutions, the business users will be able to obtain the information they need, whenever they need it.Key responsibilities:Using strong SQL skills to create and maintain the data transformation processes that load our analytics environmentCreating, enhancing, and tuning tabular models for our growing infrastructureAssisting in creating dimensional modelsWriting performant DAX measures to find insightsOptimizing data transformations for current and future data loadsAssisting stakeholders by providing appropriate BI advice, direction, and solutions, including data models, Power BI reports, SSRS reports, or dashboardsWriting and tuning SQL-stored procedures for reports, infrastructure, and ETLParticipating in performance enhancements to our warehouse and SSAS implementationsCore strengths:Advanced SQL skills, including stored procedure creation and tuningData transformation and/or integration processing using ETL/ELT technologies such as SSISReport creation and maintenance using tools such as SSRS, Power BI, or TableauBasic understanding of dimensional modelingAdditional skills and knowledge:Familiarity with SSAS and tabular modelsFamiliarity with DAX and/or MFFamiliarity with Python