Senior BI Developer - Platform Migration
About the Role
We are seeking an experienced Senior Business Intelligence Developer to lead a critical, large-scale migration initiative from MSSQL/MicroStrategy environment to a modern data platform built on Databricks, dbt, and Power BI. This is a transformational role that will shape the future of analytics infrastructure and empower data-driven decision making across the organization.
Key Responsibilities
Migration Leadership
Design and execute the migration strategy from MSSQL and MicroStrategy to Databricks, dbt, and Power BI
Assess existing BI reports, dashboards, and data models to determine migration priorities and requirements
Rebuild and optimize MicroStrategy reports and dashboards in Power BI, ensuring feature parity and improved performance
Translate SQL-based data 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 that meet business requirements
Optimize SQL queries and Spark-based transformations for performance on Databricks
Implement version control, testing, and CI/CD practices for analytics code
Build reusable data marts and semantic layers to support self-service analytics
Collaboration \& Documentation
Partner with data engineers, analysts, and business 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 with proven track record of delivering enterprise analytics solutions
Strong MicroStrategy experience, including report development, dashboard creation, and platform administration
Advanced SQL skills with experience in MSSQL Server and query optimization
Power BI expertise, including DAX, Power Query, data modeling, and report design
dbt proficiency with understanding of data transformation best practices, testing, and documentation
Databricks/Spark experience or strong willingness to learn cloud-based data platforms
Migration Experience
Demonstrated experience with large-scale BI platform migrations or transformations
Ability to assess legacy systems and design modern architectural solutions
Experience with data validation and reconciliation during migration projects
Additional Skills
Understanding of dimensional modeling, star schemas, and data warehouse concepts
Familiarity with version control systems (Git) and DevOps practices
Knowledge of data governance, security, and compliance requirements
Strong analytical and problem-solving abilities
Preferred Qualifications
Experience with Azure cloud services (Azure Data Factory, Azure SQL, etc.)
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
Competencies
Communication: Ability to explain complex technical concepts to non-technical stakeholders
Leadership: Self-motivated with ability to drive projects independently
Adaptability: Comfortable working in a fast-paced, evolving environment
Attention to Detail: Meticulous about data accuracy and code quality
Collaboration: Team player who thrives in cross-functional environments
About Matrix:
Matrix is a global, dynamic, fast-growing technical consultancy leading technology services company with 13,000 employees worldwide. Since its foundation in 2001, Matrix has made numerous acquisitions and executed some of the largest, most significant projects. The company specializes in implementing and developing leading technologies, software solutions, and products. It provides its customers with infrastructure and consulting services, IT outsourcing, offshore, training and assimilation, and serves as representatives for the world's leading software vendors. With vast experience in private and public sectors, ranging from Finance, Telecom, Health, Hi-Tech, Education, Defense, and Security, Matrix's customer base includes major organizations in Israel and a steadily growing client base worldwide. We are comprised of talented, creative, and dedicated individuals passionate about delivering innovative solutions to the market. We source and foster the best talent and recognize that all employees' contributions are integral to our company's future. Matrix's success is based on a challenging work environment, competitive compensation and benefits, and rewarding career opportunities. We encourage a diverse work environment of sharing, learning, and growing together. Come and join the winning team! You'll be challenged and have fun in a highly respected organization.
To Learn More, Visit: www.matrix-ifs.com
Equal Opportunity Employer:
Matrix is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Matrix is committed to the principle of equal employment opportunity for all employees, providing employees with a work environment free of discrimination and harassment. All employment decisions at Matrix are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, family or parental status, or any other status protected by the laws or regulations in our locations. Matrix will not tolerate discrimination or harassment based on any of these characteristics. Matrix encourages applicants of all ages.