Analytics Engineer

At Kustom US, we bring order to chaos after disaster strikes – restoring property, stability, and peace of mind for businesses and families across the country.

The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and data architecture that support reporting, analytics, and business intelligence initiatives across the organization. This IT role is a critical cross‑functional business partner to the Sales, Operations, and Leadership teams that will enable enterprise reporting in Power BI by structuring, integrating, migrating, and validating data that is accessible, secure, and optimized for dashboards and reporting solutions.

• Design, build, and maintain scalable data pipelines and Snowflake data structures to ingest, transform, and store data from multiple internal and external sources
• Develop and manage data models optimized for analytics and reporting use cases
• Ensure data quality, accuracy, consistency, and integrity across all data platforms
• Optimize database and query performance for large datasets

• Develop and maintain Power BI data models, datasets, and semantic layers
• Enable reliable Power BI connectivity to data warehouses, SQL databases, APIs, and cloud-based sources
• Partner with analysts and business users to support Power BI dashboards, reports, and self‑service analytics
• Own the Power BI semantic layer strategy (dataset design, measures, governance, and performance)
• Implement data refresh strategies, row‑level security (RLS), and performance tuning for Power BI solutions

• Integrate data from enterprise systems (e.g., ERP, HRIS, Payroll, CRM, finance, operations)
• Work with APIs, flat files, and third‑party data sources to automate data ingestion
• Support real‑time and batch data processing as needed

• Implement data governance standards, documentation, and best practices
• Ensure compliance with data security, privacy, and access control requirements
• Monitor and troubleshoot data pipeline failures and data quality issues
• Collaborate with IT and business stakeholders to translate reporting and analytics requirements into technical solutions
• Provide ongoing support and enhancements to existing data infrastructure
• Document data pipelines, data models, and technical processes
• Hands‑on experience building data pipelines using ETL/ELT tools or custom frameworks
• Proven experience supporting Power BI connectivity, datasets, semantic models, and data models
• Translate business reporting needs into scalable, dashboard‑ready data models and curated datasets, ensuring accuracy through validation, reconciliation, and documented definitions
• Experience working with structured and semi‑structured data

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent experience)
• 3–7 years of experience in data engineering, database development, or analytics engineering
• Strong experience with SQL and relational databases (e.g., SQL Server, Postgre
  
  SQL, Oracle, MySQL)
• Prior experience supporting HR, payroll, finance, or operational data environments
• Experience with cloud data platforms (Azure, AWS, or GCP)
• Preferred familiarity with Azure Data Factory, Synapse, Databricks, or similar tools
• Knowledge of Python, Spark, or similar data processing languages preferred

• A Culture That Wins Together – Teamwork, integrity, and a growth mindset define us
• Total Rewards Package – Competitive weekly pay with a comprehensive benefits package including health, dental, vision, 401(k), PTO, and more
• Real Career Growth – Training, mentorship, and advancement opportunities to move into roles across the company

Founded in 1968, Kustom has spent decades earning a stellar reputation as a nationally acclaimed, industry‑leading property restoration firm. We offer unparalleled full‑service restoration and emergency services to commercial, industrial, and residential clients. Our legacy is built on innovative thinking, meticulous attention to detail, and a commitment to exceptional service, ensuring that life and…