Senior BI Developer

Daisy Brand - Dallas, TX

Full-time - Senior

Onsite - Dallas, TX

501-1,000 employees

Food Manufacturing

About the position

Daisy Brand is seeking a Senior BI Developer to join our team in Dallas, TX. This role is pivotal as we modernize our data platform and visualization strategies, transitioning from traditional solutions like SQL Server, SSIS, and Tableau to a more advanced cloud data platform utilizing Azure SQL Managed Instance and Microsoft Fabric. The ideal candidate will not only have a deep technical understanding of Power BI but also possess strong business acumen to effectively translate customer use cases into compelling and efficient visualization designs. This position will drive innovation, enhance user experience, and enable data democratization across our organization. In this role, you will collaborate with subject matter experts to determine business information and reporting requirements, fostering improved alignment of technology initiatives with business strategies. You will provide technical and architectural guidance to projects and teams, ensuring effective reporting and analyses. Your responsibilities will include defining, designing, developing, documenting, and maintaining Power BI data models and visualizations, implementing advanced techniques using Power BI Premium, XMLA Endpoints, and Tabular Editor 3 to elevate our analytics capabilities. You will also work with various data sources, oversee the analysis, design, implementation, and support of the company data warehouse, and stay informed about new developments and technologies through continuous learning. This position requires a strong analytical mindset, excellent communication skills, and the ability to navigate ambiguity in a fast-paced environment. As a full-time position located at our Dallas office, occasional travel to Daisy's manufacturing sites may be required, and this role adheres to the hybrid/work-from-home policies for the Corporate IT team.

Responsibilities

• Collaborate with subject matter experts to determine business information and reporting requirements.
• Foster improved alignment of technology initiatives with business strategies by building and maintaining relationships with technology teams and business partners.
• Provide technical and architectural guidance to projects and teams to ensure effective reporting and analyses.
• Define, design, develop, document, and maintain Power BI data models and visualizations.
• Implement advanced techniques using Power BI Premium, XMLA Endpoints, and Tabular Editor 3 to elevate analytics capabilities.
• Develop and maintain complex DAX, Power Query formula language (M), and T-SQL queries.
• Stay ahead of data science trends and emerging tools and technologies to enhance frameworks, processes, and best practices.
• Provide guidance on Power BI security, user mapping, and app deployment.
• Maintain adherence to security and architectural standards as well as usability design principles.
• Work with various data sources such as SQL Server, DataVerse, Excel, Azure SQL, SharePoint Lists/Libraries, API based data, and unstructured data.
• Oversee and conduct analysis, design, implementation, and support of the company data warehouse, including developing ETL routines.

Requirements

• 8+ years relevant experience.
• Thorough understanding of PowerBI architecture and capabilities such as CI/CD pipelines, data modeling, security, architecture, etc.
• Experience with Azure SQL Database, Azure SQL Managed Instance, On-Premise SQL Server and Azure DevOps.
• Strong knowledge of PowerBI dashboard development, Data Visualization concepts, ETL processes, Data Architectures, and Data Modeling.
• Must have an analytical mind, be a critical thinker and problem solver.
• Excellent communication skills (verbal and written) and ability to effectively communicate with both business and technical teams.
• Ability to deal with ambiguity and competing objectives in a fast-paced environment.
• Proven experience working in a team oriented, collaborative environment.

Nice-to-haves

• Familiarity with Azure Data Factory, Azure Synapse, and/or SSIS
• Knowledge of Azure services, including Azure Data Lake
• Experience implementing API calls
• Experience with manufacturing data
• Knowledge of D365 Finance and Operations data

Benefits

• A no-deductible, $0 premium option for employee-only health coverage.
• 401(k) with 50% company match on first 8% of earnings you contribute.
• Safe harbor and profit-sharing company contributions to 401(k).
• Company paid short- and long-term disability coverage.
• Company paid 2X annual salary life and AD&D insurance.
• 4 weeks annual paid time off.
• Extra time off for volunteering.
• Tuition reimbursement.
• Fitness membership reimbursement.