Senior Data Warehouse Engineer

Job Description

• Drive analysis, architecture, design, and development of Cloud based data warehouse and business intelligence solutions • Design and develop data flows and models for data warehousing and self-serve reporting • Design and build extensible data acquisition and integration solutions to meet business reporting and analytics needs • Implement a comprehensive framework to support logging, profile and audit high volume high frequency file processing supporting multiple formats • Automate and optimize existing data processing workloads to integrate with the enterprise data warehouse • Understand and translate business needs into data models to support long-term, scalable, and reliable solutions • Create data models for self-serve reporting • Build data pipelines from systems such as CRM, ERP and internal applications with the emphasis on scalability and reliability • Partner with business users, senior architects, and infrastructure engineers to form complete end-to end-solutions • Drive data quality across the organization; develop best practices for standard naming conventions and coding practices to ensure consistency of data models and tracking • Prepare to respond to ad hoc reporting needs of business functions • Work in a fast-paced environment and perform effectively in a sprint based agile development environment • Collaborate with developers and analysts on technical and functional designs • Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries • Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time • This remote opportunity is available to US based persons

Qualifications

• Bachelor’s degree in computers Ince or related field • At least 8 year of overall experience building data warehouse solutions with solid data modeling skills • At least 3 years of hands-on experience in building Data Warehouses in Snowflake or Redshift • At least 4 years of experience in developing data pipelines using Python, PySpark or Scala • Experience with API design and development using RESTful and/or SOAP protocols • At least 2 years of experience creating DBT models and in a cloud, data Warehouses platform • Knowledge of advanced SQL scripting and ability to write complex queries • Experience using Rivery or new age ELT tools like Fivetran, Matillion etc. • Understanding of agile methodologies such as CI/CD, Applicant Resiliency, and Security • Experience working with various file formats at scale • Experience with AWS. Familiarity with AWS Athena, Glue, Data Pipeline is a plus • At least 2 years of experience with Salesforce Health Cloud, Marketing Cloud and NetSuite Schemas • Experience designing highly scalable ETL/ELT processes with complex data transformations, data formats including error handling and monitoring • Excellent analytical, problem solving, and troubleshooting skills, and solid communication skills

Benefits

• A competitive compensation package in line with leading technology companies • As a remote friendly company we are committed to providing opportunities for all who join to further build relationships, increase cross-functional collaboration, and celebrate our accomplishments. • Opportunity for equity participation • Unlimited vacation with manager approval • 16 weeks of 100% paid parental leave for delivering parents; 8 weeks of 100% paid parental leave for non-delivering parents • 100% Employer sponsored healthcare, dental, and vision for you, and 80% coverage for your family; Health Savings Account and Flexible Spending Account options • 401k retirement savings plan