Manufacturing Engineer, Electrical/Electronics – Entry Level
Boeing
Lead Data Modeling Engineer, Azure
Acosta
full-time
Posted on:
Location: Florida, North Carolina • 🇺🇸 United States
Visit company websiteJob Level
Senior
Tech Stack
AzureETLRDBMS
About the role
- Architecture, design, development and deployment of data modeling and reporting capabilities using Microsoft Azure Analysis Services, Azure Databricks and Microsoft Power BI.
- Part of the Enterprise Data Platform team managing ingestion, storage, modeling, and consumption of data for Acosta and clients.
- Accountable for optimization and automation of BI solutions within Acosta's Enterprise Data Platform.
- This position is a hybrid role open to anywhere; expected to work on-site close to an Acosta Group office at least 3 days a week; ideal locations: Jacksonville, FL; Lewisville (Dallas), TX; Rogers, AR; Charlotte, NC.
- This position is not eligible for Visa Sponsorship.
- Development of complex/advanced AAS Tabular models with large volumes of data and advanced business logic, and enhancements to existing models.
- Creation of complex and efficient views in Azure Databricks to support AAS Tabular modeling.
- Work closely with Project Managers, BI Architects, BI QA Analysts and Data Engineering Developers in Agile and Waterfall settings to deliver solutions to stakeholders.
- Performance monitoring, tuning and optimization of AAS and Power BI models.
- Mentor Junior and Senior Data Modelers in PBI and AAS development, focusing on optimization and automation.
- Research and POC new and emerging BI technologies and share solutions within the Data Platform team.
- Focus on continual self-development of BI, modeling, and data skills.
- Automation and scheduling/triggering of data refreshes for the AAS models.
- Provisioning and sizing of AAS resources.
- Development and enhancement of complex/advanced Power BI reports as required.
- Familiarize with Acosta's services and supporting data solutions (NARS, POS, CPG Syndicated).
- Think critically about delivered data model solutions and extract actionable insights.
- Other duties as assigned.
Requirements
- Bachelor’s degree or equivalent work experience.
- Microsoft Certification: Data Analyst Associate.
- MCSA: BI Reporting.
- Microsoft Certification: Azure Data Engineer Associate.
- 10 years of related work experience.
- 7 years of experience in Microsoft SSAS, AAS and data warehouse design for Business Intelligence.
- 5 years of experience with data analytics and various report development software.
- 5 years of experience in Power BI including M Query and DAX development.
- Experience working with ETL tools such as Azure Databricks.
- Expert in Power BI, inclusive of the Vertipaq storage engine (compression/segmentation), performance measurement and monitoring, analyzing query plans, advanced optimization of large models.
- Advanced understanding of Relational Database Management Systems (RDBMS) foundations and best practices for optimizing data and reporting.
- Advanced proficiency in AAS (or SSAS) tabular models including loading data, relationships, modeling, analyzing query plans, security, processing, and partitioning.
- Solid foundation in Azure Databricks including navigation within workspaces, querying notebooks, usage of gateways and DSNs.
- Good problem solving and debugging skills.
- Effective written and verbal communication skills.
- Physical Requirements: Seeing; Listening; Color Perception.
