What are the responsibilities and job description for the BI Developer position at The MJ Companies?
About The Job
The MJ Companies are seeking a BI Developer to design, develop, and maintain innovative analytics solutions that empower both associates and clients with actionable, data-driven insights.
In this role, you’ll build and enhance Power BI dashboards and reports, optimize data models for performance, and collaborate closely with data engineers, analysts, and business units to understand needs and deliver effective solutions. You’ll also ensure proper governance, security, and data quality across all BI assets.
The ideal candidate combines strong technical expertise in BI tools with a deep understanding of business objectives, translating complex data into clear, compelling visualizations that tell the story behind the numbers, support informed decision making, and enable our teams to effectively consult with our clients.
Essential Functions
The MJ Companies are seeking a BI Developer to design, develop, and maintain innovative analytics solutions that empower both associates and clients with actionable, data-driven insights.
In this role, you’ll build and enhance Power BI dashboards and reports, optimize data models for performance, and collaborate closely with data engineers, analysts, and business units to understand needs and deliver effective solutions. You’ll also ensure proper governance, security, and data quality across all BI assets.
The ideal candidate combines strong technical expertise in BI tools with a deep understanding of business objectives, translating complex data into clear, compelling visualizations that tell the story behind the numbers, support informed decision making, and enable our teams to effectively consult with our clients.
Essential Functions
- Develop interactive dashboards and report templates in Power BI that clearly communicate insights and trends.
- Create data visualizations that tell a story, transforming complex data into actionable information that supports both business insights and client decision making.
- Apply critical thinking to analyze data patterns, identify key drivers, and recommend meaningful actions based on findings.
- Optimize report performance by designing efficient, scalable data models.
- Collaborate with data engineers and business partners to ensure accurate and timely data availability for BI solutions.
- Implement role-based access controls for BI reports and dashboards.
- Document BI solutions, including data sources, models, and visualization logic.
- Manage the onboarding of new users and ensure proper access levels.
- Use CI/CD pipelines to develop, test, and deploy BI features to production.
- Create SQL views from gold/endorsed schemas to support analytics product features.
- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field.
- Preferred: Certifications in Power BI, Azure, or related BI technologies.
- Proven experience designing and developing BI dashboards and reports, preferably in Power BI.
- Proficiency in SQL for data modeling, transformation, and view creation.
- Experience implementing role-based security, managing CI/CD pipelines, and maintaining governance for BI solutions.
- Strong collaboration, communication, and problem-solving skills.
- Preferred: Experience in Employee Benefits or Property & Casualty domains and familiarity with Agile methodologies.
- Design, build, and optimize BI dashboards and data models to ensure accuracy and performance.
- Implement and maintain secure, role-based access controls across BI assets.
- Develop and manage SQL-based data views and transformations to support analytics solutions.
- Utilize CI/CD pipelines to deploy, test, and update BI features efficiently.
- Document, standardize, and continuously improve BI processes and solutions.