Business Intelligence Developer

Description

The Business Intelligence Developer designs, builds, and supports modern business intelligence and automation solutions that enable data-driven decision-making across the organization. This role combines expertise in data integration, reporting, and analytics to improve business processes through self-service reporting, workflow automation, and trusted data.

Working closely with business stakeholders and IT teams, the Business Intelligence Developer develops dashboards, semantic data models, and workflow automations that improve operational efficiency, reduce manual effort, and provide timely, trusted business insights. The role ensures that solutions are built on secure, governed, and high-quality data, and applies modern development tools, including AI-assisted tools, responsibly and effectively.

Business Intelligence & Analysis

• Design, develop, and maintain enterprise dashboards, scorecards, and reports, using modern development tools, including AI-assisted tools, to work efficiently.
• Build and maintain semantic models, data marts, and reporting datasets that provide a consistent source of truth.
• Develop KPIs, metrics, and executive reporting aligned with organizational goals.
• Partner with business units to understand reporting needs and translate requirements into scalable analytics solutions.
• Improve self-service analytics capabilities by creating reusable datasets, documentation, and user-friendly reporting experiences.

Workflow Automation

• Design, develop, and deploy workflow automations that reduce repetitive manual processes, using modern low-code and workflow automation tools.
• Identify opportunities for automation and process improvement across operations, knowledge management, customer service, and internal productivity.
• Evaluate emerging technologies, including AI-assisted tools, and recommend practical applications aligned with organizational objectives.
• Monitor the performance of automated solutions and continuously improve accuracy, usability, and business value.

Data Integration & Engineering 

• Develop and maintain secure integrations between enterprise applications, databases, APIs, cloud services, and reporting platforms.
• Design ETL/ELT processes that ensure timely, accurate, and reliable data availability.
• Optimize SQL queries, data models, and data pipelines for performance and scalability.
• Support data governance by maintaining metadata, data quality standards, and documentation.
• Collaborate with application owners to ensure data consistency across systems.

Data Governance & Security

• Ensure reporting and automation solutions comply with organizational security, privacy, and governance standards.
• Implement role-based security and appropriate access controls.
• Promote responsible use of data and emerging technologies, including AI-assisted tools, with attention to transparency and data protection.
• Assist in establishing standards for reporting, automation, documentation, and lifecycle management.

Collaboration & Business Partnership 

• Serve as a trusted advisor to business leaders on reporting, analytics, and automation opportunities.
• Facilitate workshops to identify automation and reporting improvements.
• Provide technical guidance and mentoring for self-service BI and automation tools.
• Create documentation, training materials, and best practices.
• Work closely with infrastructure, development, security, and business teams to deliver integrated solutions.
• Other Duties as Assigned

Requirements

To perform the essential functions of this position successfully, an individual should demonstrate the following competencies:

• Knowledge of business intelligence, data modeling, and reporting principles and best practices.
• Knowledge of SQL, relational database structures, and data integration processes (ETL/ELT).
• Knowledge of modern analytics, data visualization, and workflow automation platforms.
• Knowledge of data governance, information security, and privacy requirements.
• Knowledge of business process analysis, workflow design, and automation methodologies.
• Skill in developing interactive dashboards, reports, and semantic data models to support business decision-making.
• Skill in designing and implementing automated workflows to improve operational efficiency.
• Skill in writing, optimizing, and troubleshooting SQL queries and integrating data from multiple systems and sources.
• Skill in analyzing business requirements and translating them into effective technical solutions.
• Skill in presenting and communicating technical concepts and recommendations to business and non-technical stakeholders.
• Skill in identifying, troubleshooting, and resolving reporting, data quality, and integration issues.
• Ability to analyze complex business challenges and develop practical, data-driven solutions that deliver measurable results.
• Ability to manage multiple priorities and projects while maintaining high standards of accuracy and quality.
• Ability to collaborate effectively with cross-functional teams, including technical and non-technical stakeholders.
• Ability to quickly learn, adapt, and apply emerging technologies to enhance organizational performance.
• Ability to exercise sound judgment in handling sensitive information and implementing secure, compliant, and well-governed solutions.

Required Qualifications

• Bachelor's degree in computer science, Information Systems, Data Analytics, Business Intelligence, or related field, or equivalent experience.
• 3–7 years of experience developing business intelligence, analytics, or data solutions.
• Hands-on experience building dashboards and reports in a modern BI platform.
• Strong analytical, communication, and problem-solving skills.

Preferred Qualifications

• Experience designing and building data pipelines and curated, analysis-ready datasets.
• Experience with Microsoft Power BI and Power Platform (Power Apps, Power Automate), which would help support existing solutions.
• Experience with cloud data platforms and pipeline tools, such as Microsoft Fabric, Azure Data Factory, or similar.
• Experience with Dynamics 365, SharePoint, Freshservice, or similar enterprise platforms.
• Experience with Python, C#, or JavaScript.
• Familiarity with AI-assisted development tools, such as Copilot or similar.
• Relevant industry certifications (for example, Microsoft).
• Ability to communicate effectively in American Sign Language (ASL)

Salary Description

70,000 - 75,000/year