Senior BI Developer

The Senior BI Developer is responsible for designing, developing, and maintaining cloud base business intelligence solutions utilizing Azure. Incumbent works closely with internal stakeholders including business analysts and developers to understand requirements and develop and support BI solutions. This role utilizes Microsoft BI tools and technologies to deliver accurate and insightful data visualizations, reports, and dashboards to drive strategic decision-making.

Essential Functions

• Lead the end-to-end design and implementation of scalable BI solutions using Azure technologies including but not limited to Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, and Azure Analysis Services
• Design, develop, and enhance data models, data warehouses, SQL queries, and ETL processes ensuring reliability, performance, and integrity across systems that will drive the business forward
• Collaborate with business analysts and development teams and other stakeholders to gather requirements and provide guidance on how data can be used to achieve business objectives
• Translate high-level business questions into data-driven insights and reporting strategies by creating and maintaining SQL queries, stored procedures, and functions to extract and transform data from various sources fostering best practices
• Design and develop interactive dashboards utilizing Power BI drill down data exploration for strategic insights and performance optimization
• Implement and oversee data security measures and ensure compliance with data governance policies including data lineage, cataloging, and stewardship frameworks
• Comply with Company and department policies and standards; performs other duties as assigned

Minimum Requirements

• Bachelor's Degree in computer science or information systems or equivalent education and/or experience
• 5 years as a BI Developer or similar role utilizing Microsoft BI technologies

Preferred Requirements

• Experience with Microsoft Azure services such as Azure Data Factory, Azure Analysis Services, or Azure Synapse Analytics.
• Experience with agile development methodologies
• Experience with mentoring and coaching other team members

Skills and Abilities

• Strong working knowledge of Microsoft SQL Server, SSIS, SSAS, and Power BI
• Ability to able to communicate stakeholders verbally and in writing, create presentations, and understand how client needs translate to steps for coding and programming professionals.
• Proficiency in SQL querying and data modeling
• Understanding of data warehousing principles and ETL processes
• Ability to work independently and as part of a team, managing multiple priorities and deadlines
• Excellent analytical and problem-solving skills including the ability to analyze the situation, identify opportunities, and take a proven, methodical approach to resolving them
• Strong communication and technical writing skills including the ability to collaborate and translate needs from both technical and non-technical stakeholders
• Knowledge of data visualization best practices and user experience design
• Ability to stay current with the latest Microsoft BI technologies and best practices and apply them as needed
• Ability to provide training and support to end users on BI tools as needed

Physical and Cognitive Demands

• Communicate/Hearing Frequently
• Communicate/Talking Frequently
• Hand/Eye Coordination Frequently
• Learn New Tasks or Concepts Frequently
• Make Timely Decisions in the Context of a Workflow Frequently
• Remember Processes & Procedures Frequently
• Repetitive Motions Frequently
• Complete Tasks Independently Constantly
• Maintain Focus Constantly
• Stationary Position (Seated) Constantly
• Vision Constantly

Travel Requirements

• 5% Occasional travel may be required for in-person meetings as business needs require

The potential compensation range for this role is below. The final offer amount would be based on various factors such as candidate location (geographical labor market), experience, and skills. $94,100.00 - $117,700.00