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 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.

Key Responsibilities

Data Architecture & Engineering

• 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

Power BI & Analytics Enablement

• 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

Systems Integration

• 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

Data Governance & Security

• 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

Collaboration & Support

• 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

Competencies & Skills

• 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

Qualifications

• Bachelors degree in Computer Science Information Systems Data Engineering or a related field (or equivalent experience)
• 37 years of experience in data engineering database development or analytics engineering
• Strong experience with SQL and relational databases (e.g. SQL Server PostgreSQL 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

Why Join Kustom

• 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 business continue smoothly for our clients nationwide.

At Kustom we unite experts who are driving the industry forward delivering positive life-changing outcomes for both commercial and residential customers. We do more than rebuild - we build trust.

If you are ready to help people navigate chaos with confidence we want to meet you.

Kustom provides equal employment opportunities to all employees and applicants for employment without regard to race color creed ancestry national origin citizenship sex or gender (including pregnancy childbirth and pregnancy-related conditions) gender identity or expression (including transgender status) sexual orientation marital status religion age disability genetic information service in the military or any other characteristic protected by applicable federal state or local laws and ordinances.

Subject to Federal State and Local laws regulations and or ordinances applicants must be able to pass pre-employment drug screening and background check.

Compensation is based on geographic location demonstrated job related skills knowledge experience education certifications etc. This job description is not intended to contain a comprehensive listing of activities duties or responsibilities that are required of the employee for this job. Activities duties and or responsibilities may change at any time with or without notice.