Data Warehouse Engineer
IntelliShift
Commack, new york
Job Details
Full-time
6/11/2024
Full Job Description
We are IntelliShift, a rapidly growing B2B SaaS company with more than 20 years of expertise in fleet management technology. IntelliShift is the fleet intelligence platform for safety and operations teams, and we empower construction, utilities, field services, and last mile delivery businesses to make the intelligent shift from siloed data using point solutions, to one simple, powerful platform. We provide these customers with a level of insight they’ve never had before to improve safety, establish next generation operational efficiency, and make intelligent decisions.
We are looking for an experienced Data Warehouse Engineer to join our software development team. We are focused on enabling our customers to make data-driven decisions that deliver value to their shareholders. This includes enabling analytical insights into their business operations, fleet management, and driver behavior. Solving these challenges involves working with technologies on the leading edge of data gathering, processing, and warehousing.
What you will do:
- Help design, build, and maintain a multi-terabyte data warehouse used across several functions and geographies.
- Participate in project planning, estimation and status activities.
- Research and resolve support tickets and escalations.
- Monitoring and management of data quality procedures and practices.
- Design, development, monitoring, and management of ELT/ETL pipelines and procedures.
- Design and development of reports, stored procedures and functions.
- Stay on top of new technology developments in data warehousing, big data processing, and other relevant fields.
What you bring:
- 2+ years' experience of Snowflake Data Warehouse or similar technology.
- Bachelor’s degree in computer science or related field.
- 4+ years and Intermediate to Advanced knowledge of SQL.
- 4+ years and Intermediate to Advanced stored procedure/function development.
- 4+ years and Intermediate to advanced stored procedure/function development.
- Solid understanding of data warehousing concepts and architecture.
- Experience developing data warehouse reports and analytic queries.
- 2+ years’ experience in SSRS or similar reporting tool.
- Attention to detail.
- Ability to research data issues and resolve them in a timely manner.
Preferable skills:
- Data replication concepts.
- Experience developing ETL/ETL using stored procedures.
- Experience with JavaScript development.
- Machine Learning experience.
The values you’ll live by as part of the team:
- Always Put the Customer First – with the customer experience in mind, build trust and loyalty.
- Embrace and Drive Change – have an innovative mindset and embrace the change.
- Think Bigger - commit to growing the organization and grow as an individual.
- Be a Good Human – treat everybody with respect and always do what is best.
- Execute with Passion and Urgency – we need to be the very best at what we do.
- Drive Trust and Transparency – open and honest communication, trust each other and take risks.
Benefits
We offer competitive compensation, commensurate with experience $115,000 - $125,000. We also offer outstanding benefits to simplify the lives of our employees and show them how much we appreciate their contributions. IntelliShift provides company-subsidized medical insurance for all employees (and largely subsidized coverage for families), dental, vision, and 401K with a 4% company contribution.