Data Warehouse Architect/Engineer Job at ZipRecruiter, Commack, NY

WFZyVXpENjAwb2x3b0doWnNGSE13dDNKTGc9PQ==
  • ZipRecruiter
  • Commack, NY

Job Description

Job DescriptionJob 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 operational efficiency, and make intelligent decisions. We are looking for an experienced Data Warehouse Architect/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 and looking for someone with proven proficiency in architecting, designing and development experience with batch and real time streaming infrastructure and workloads. What you will do:

  • Help design, build, and maintain a multi-terabyte data warehouse in support of Data and Analytics and Data Product use cases
  • Implementing scalable, high-performance data pipelines for data ingestion, storage. processing and transformation to support analytics and ML pipelines.
  • Develop standards for database design and implementation of various strategic data architecture initiatives around data quality, data management policies/standards, data governance, privacy and metadata management.
  • 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.
  • Participate in project planning, estimation and status activities
  • Research and resolve support tickets and escalations.
Requirements What you bring:
  • Bachelor’s degree in computer science or related field.
  • Experience and working knowledge of streaming platforms, typically based around Kafka.
  • Strong grasp of Azure & AWS data platform services and their strengths/weaknesses.
  • 3+ years' experience of Snowflake Data Warehouse or similar technology.
  • 5+ years and Intermediate to Advanced knowledge of SQL.
  • 5+ years and Intermediate to Advanced stored procedure/function development.
  • 5+ 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.
  • 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:
  • Customer-Obsessed- Our customers are at the center of everything we do. When they win, we win. We’re more than just a vendor; we’re committed partners.
  • No-Box Innovation- Forget thinking outside the box—what box? We embrace bold ideas and build what hasn’t been built before to drive our customers and ourselves forward.
  • Growth Through Friction- Not all friction is bad. We challenge inefficiencies, drive innovation, push for a stronger business, and break through limits.
  • Trust Through Action- Promises don’t build trust—actions do. We lead with transparency, act with integrity, and stay committed to always doing right by those we work with
  • Own It- Every action matters, so make it count. We are accountable for our work, own our outcomes, and always strive to make a positive difference.
Benefits We offer competitive compensation, commensurate with experience $150,000 - $170,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. #J-18808-Ljbffr ZipRecruiter

Job Tags

Shift work,

Similar Jobs

HCA HealthONE Rose

Registered Nurse Lactation Consultant Job at HCA HealthONE Rose

 ...have the career opportunities as a Registered Nurse Lactation Consultant you want in your current role? We invest in what matters most to...  ...employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital... 

Talentoma

Customer Service Representative Job at Talentoma

 ...Job Description Job Title: Remote Customer Service Representative Monthly Pay: $3,700 $4,500 Summary: We are looking...  ...others, are comfortable using a computer, and want a stable work-from-home job, this is a great opportunity to grow your customer service... 

Evergreen Academy

Preschool Teaching Assistant Job at Evergreen Academy

 ...through innovative, standards-exceeding curriculum and high-impact teaching practices. Our focus on personalized learning, social and...  ...About the Role Join our team as a Preschool Teaching Assistant where you will inspire young minds with our enriched curriculum... 

Crew Carwash

Full or Part-Time Customer Service Team Member 15 Job at Crew Carwash

 ...leading quality for our customers Help maintain a park-like environment (inside and outside) Crews commitments to you: ~$15 - $16 per hour + incentive pay ~ Daily pay options available at no cost to you ~ Paid Time Off + 6 paid holidays each year (Full Time... 

vaco

IT Security / Compliance Analyst (GRC) Job at vaco

 ...Vaco is partnering with an enterprise client on the search for an GRC Analyst to support compliance initiatives, security audits, and metrics reporting across the organization. This is a 4 month contract position supporting the companys risk management and information...