Data and Power BI Engineer

About Our Client

The organization is a forward-thinking provider in the legal services sector, specializing in family law solutions. They are currently undergoing a significant digital transformation, moving toward a data-driven culture that leverages advanced business intelligence and data engineering. Their primary goal is to build a secure, scalable data infrastructure that supports accurate reporting today while paving the way for AI-driven automation and predictive analytics in the future.

About the Opportunity

The Data and Power BI Engineer is a leadership-level technical role responsible for the architecture and integrity of the organization’s data environment. You will lead the development of the Power BI semantic model, establishing a "single source of truth" across the enterprise. This fully remote position requires a proactive professional who can translate complex business needs into robust data solutions, ensuring the organization is fully prepared for next-generation AI insights.

Responsibilities

• Power BI Ecosystem Ownership: Own and enhance the full reporting environment, including the development of sophisticated dashboards, reports, and datasets.
• Data Modeling & Architecture: Design and maintain scalable star schema data models and standardized reporting structures to ensure high performance and clarity.
• Pipeline Engineering: Build and troubleshoot data pipelines; ingest, clean, and validate data from diverse sources including APIs, SQL, Salesforce, and financial systems.
• Strategic Partnership: Collaborate with Finance, IT, and Operations to define core business KPIs, reporting logic, and data definitions.
• AI Readiness: Prepare and structure datasets specifically for future integration with AI, automation, and predictive analytics tools.
• Governance & Security: Manage the Power BI Service ecosystem, including refresh schedules, access control, deployments, and strict data confidentiality standards.
• Advanced Transformation: Utilize Power Query and M code for complex data shaping, deduplication, and performance tuning.

Requirements

• Professional Experience: Minimum of 4 years in business intelligence, data engineering, or analytics engineering.
• Technical Mastery:
• Expert-level experience in developing Power BI semantic models and dashboards.
• Deep proficiency in DAX and Power Query (M).
• Strong background in building and maintaining scalable data models (Star Schema).
• Systems Knowledge: Hands-on experience with data pipelines, dataflows, and integrating cloud applications via APIs and SQL.
• Analytical Ability: Proven ability to translate abstract business requirements into technical reporting and data solutions.
• Work Style: Ability to work independently and maintain high standards of documentation and data governance in a remote-first environment.

Compensation & Benefits

Compensation

• The pay range and compensation package will be determined based on the candidate’s experience, skills, and other relevant factors.

Benefits & Perks

• Remote Work: This is a 100% remote position, offering geographic flexibility and autonomy.
• Professional Impact: Lead the data strategy for a major family law services provider during a critical AI-readiness phase.
• Culture: Join an organization that values diversity, inclusive environments, and data-driven decision-making.

Equal Opportunity Statement

Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

About RemoteHunter

RemoteHunter is not the Employer of Record (EOR) for this role. Our purpose in this opportunity is to connect exceptional candidates with leading employers. We help job seekers worldwide discover roles that match their goals and guide them to complete their full application directly through the hiring company’s career page or ATS.