Sr. Data Engineer

About the Role

Key Responsibilities

• Get a deep understanding of data requirements, business rules and metrics needed by Analytics and Reporting teams.
• Explore existing and new data sources and ingest data into Snowflake, as needed.
• Write ETL, stored procedures, API calls, Python scripts to model and build transformations and validate the data to ensure business requirements are met.
• Build optimal data pipelines and/or scheduled jobs to refresh data on cadence.
• Create data models and document design and process flow.
• Validate the objects built in the data warehouse and track issues to resolution.
• Develop and maintain positive working relationships with partner teams in a collaborative team environment.

Requirements

• Bachelor's Degree in Computer Engineering, Computer Science, a related subject area or equivalent experience.
• Minimum 4-5 years in data engineering and/or BI development including Advanced SQL, writing ETL and stored procedures.
• Solid understanding of Data warehouse and data mart concepts.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Experience with Python or other scripting languages.
• Excellent communication skills with experience collaborating with various functional teams.
• At least 18 years of age and legally authorized to work in the United States.

Nice to Have

• 2-3 years' experience with building modeled data in Snowflake.
• Experience with Azure Synapse, Azure Data Factory, and Azure Databricks.
• Experience with data visualization development in Power BI.
• Experience with Salesforce.com, especially Salesforce APIs.
• Experience with Teradata and Oracle.
• Experience working with sales & commissioning, marketing, and/or billing data.

Qualifications

• Bachelor's Degree in Computer Engineering, Computer Science, or related field.
• Minimum 4-5 years in data engineering or BI development.
• Experience with Advanced SQL, ETL, stored procedures, and data warehouse concepts.
• Experience with Python or scripting languages.

Benefits & Perks

• Competitive base salary and compensation package.
• Annual stock grant, employee stock purchase plan, 401(k).
• Access to free, year-round money coaches.
• Medical, dental, and vision insurance.
• Flexible spending account, paid time off, and up to 12 paid holidays.
• Paid parental and family leave, family building benefits, back-up care, childcare subsidy, tuition assistance, college coaching.
• Short- and long-term disability, voluntary AD&D, accident, life, and disability insurance.
• Mobile service & home internet discounts, pet insurance, transit programs.