Ahava Services · 4 hours ago
Data Engineer Power BI
Ahava Services is seeking a Senior Data Platform Developer to assist in the migration of legacy application case management systems and related data into modernized, scalable, and cloud-based architectures. The role involves designing and maintaining data pipelines, developing data warehouses, and implementing Power BI models while ensuring data quality and compliance.
Responsibilities
Design, build, and maintain enterprise-scale data pipelines using Azure Data Factory (ADF)
Develop and optimize Azure SQL–based data warehouse s, data marts, and complex transformation logic
Architect and implement Power BI semantic models using DAX, Power Query (M), and dimensional modeling (star schema) best practices
Ensure data pipelines meet performance, reliability, security, and compliance standards
Lead legacy system analysis, data profiling, cleansing, and transformation activities
Collaborate with stakeholders to define and document legacy and future-state data requirements
Develop and execute data migration strategies for operational and case management systems
Coordinate data synchronization and bridging efforts to support phased platform implementations
Ensure data quality, integrity, and alignment with modernized systems
Lead and mentor developers and analysts on data integration and transformation best practices
Oversee resource planning, task allocation, and status reporting for data conversion efforts
Collaborate with business users, system integrators, architects, and data scientists
Evaluate and enhance data architecture to improve scalability, performance, and innovation
Qualification
Required
8+ years of progressive experience in Data Warehouse/Data Mart environments, with a focus on cloud-based solutions
Advanced expertise with Azure Data Factory (ADF) and Azure SQL Server
Proven ability to deliver enterprise-grade Power BI semantic models, including advanced DAX and Power Query transformations
Demonstrated experience in legacy data migration, including strategy definition, mapping, cleansing, and execution
Proficient in SQL and experienced with data modeling methodologies (e.g., Kimball, Inmon, Boyce-Codd)
Familiarity with other cloud and big data platforms such as Databricks, Snowflake, AWS, or GCP
Strong understanding of data governance, security, and compliance principles
Excellent problem-solving, debugging, and analytical skills, particularly within large and complex data ecosystems
Proven ability to lead cross-functional teams and communicate effectively with both technical and non-technical stakeholders
Preferred
Experience implementing CI/CD pipelines and infrastructure-as-code in a data engineering context
Exposure to DevOps practices for data operations and delivery
Experience supporting phased data bridging and live system cutovers during system modernization efforts
Knowledge of data cataloging, metadata management, and data lineage tools
Company
Ahava Services
Ahava Services is a salesforce consultancy that offers staff augmentation, cloud-based services, and CRM implementation for businesses.
H1B Sponsorship
Ahava Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (4)
2023 (1)
Funding
Current Stage
Early StageRecent News
Company data provided by crunchbase