Business Intelligence Developer

About the Role:

Senior Business Intelligence (BI) Developer

Databricks, dbt, and Power BI

Key Responsibilities:

Migration Leadership

• Design and execute migration strategy from MSSQL and MicroStrategy to Databricks, dbt, and Power BI.
• Assess existing BI reports, dashboards, and data models to prioritize migration tasks.
• Rebuild and optimize MicroStrategy reports and dashboards in Power BI with feature parity and improved performance.
• Translate SQL-based transformations into dbt models following best practices.
• Establish data quality validation processes to ensure migration accuracy.
  

Technical Development

• Develop scalable data models and transformation pipelines using dbt on Databricks.
• Create interactive, visually compelling Power BI dashboards and reports.
• Optimize SQL queries and Spark transformations for performance on Databricks.
• Implement version control, testing, and CI/CD for analytics code.
• Build reusable data marts and semantic layers for self-service analytics.
  

Collaboration & Documentation

• Partner with data engineers, analysts, and stakeholders to understand requirements.
• Document migration processes, data lineage, and technical architecture.
• Train team members and end-users on new BI tools and capabilities.
• Establish best practices and governance standards for the new platform.
  

Required Qualifications:

Technical Expertise

• 5+ years of BI development experience delivering enterprise analytics solutions.
• Strong MicroStrategy experience (report development, dashboards, platform administration).
• Advanced SQL skills with experience in MSSQL Server and 5query optimization.
• Expertise in Power BI (DAX, Power Query, data modeling, report design).
• Proficiency in dbt, including transformations, testing, and documentation.
• Databricks/Spark experience or strong willingness to learn cloud-based platforms.
  

Migration Experience

• Proven experience with large-scale BI platform migrations or transformations.
• Ability to assess legacy systems and design modern architecture.
• Experience with data validation and reconciliation during migrations.
  

Additional Skills

• Knowledge of dimensional modeling, star schemas, and data warehousing concepts.
• Familiarity with version control systems (Git) and DevOps practices.
• Understanding of data governance, security, and compliance.
• Strong analytical and problem-solving abilities.
  

Preferred Qualifications

• Experience with Azure cloud services (ADF, Azure SQL).
• Knowledge of Python for data processing and automation.
• Certifications in Power BI, Databricks, or dbt.
• Experience with agile project methodology.
• Background in data architecture or data engineering.
  

Core Competencies

• Communication: Explaining complex technical concepts to non-technical stakeholders.
• Leadership: Driving projects independently.
• Adaptability: Comfortable in a fast-paced, evolving environment.
• Attention to Detail: Ensuring data accuracy and high-quality code.
• Collaboration: Thrives in cross-functional teams.
  

About Matrix:

13,000 employees worldwide

Equal Opportunity Employer:

equal employment opportunities

Learn More: