Embrace and deliver our BOLT Core Values to each other and our clients
Design, build, and maintain robust ETL and ELT pipelines
Develop and manage scalable data warehouse and data lake solutions
Ensure data integrity, reliability, and performance across systems
Optimize data storage, transformation, and retrieval processes
Implement data modeling best practices for analytics and reporting environments
Translate complex datasets into actionable insights
Develop dashboards, reports, and visualizations that support business decision-making
Partner with stakeholders to define KPIs and measurement frameworks
Validate data accuracy and troubleshoot inconsistencies
Work cross-functionally with software developers and project managers to support application development and client solutions
Assist in designing data architecture that aligns with custom software builds
Provide input on data strategy, governance, and best practices
Document data flows, transformations, and system architecture clearly and thoroughly
Monitor data systems for performance bottlenecks
Recommend and implement improvements for efficiency and scalability
Support cloud cost optimization initiatives across Azure and AWS environments

Requirements

5+ years of experience in data analytics, data engineering or a related role
Extensive hands-on experience with Azure Data Factory, Databricks, Microsoft Fabric, and AWS Glue
Strong knowledge of data warehouse and data lake architecture
Experience building and maintaining ETL or ELT pipelines
Proficiency in SQL and at least one scripting language such as Python
Experience working within Azure and AWS cloud ecosystems
Experience working with APIs, including RESTful services, authentication methods, data ingestion, and integration patterns
Strong analytical skills with attention to detail and data accuracy
Clear communicator who translates technical insights into business value
Self-directed and collaborative, able to manage multiple priorities.

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
Employee Assistance Program (EAP)
401(k) with Company Match
$50,000 Company Paid Basic Life Insurance
Short & Long Term Disability Provided by Company
Flexible PTO (Paid Time Off)
Annual Learning & Development Fund
Strong Emphasis on Work-Life Balance
Flexible Work Arrangements

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLELTdata warehousedata lakeSQLPythondata modelingdata architecturedata transformationdata visualization

Soft Skills

analytical skillsattention to detailclear communicationcollaborationself-directedstakeholder engagementproblem-solvingtime managementcross-functional teamworkbusiness decision-making