Staff Software Engineer - Data Engineer

About the Role

Key Responsibilities

• Guide the creation of detailed solution artifacts that meet business needs and adhere to industry standards.
• Develop technology solutions in sync with business and strategic objectives.
• Collaborate with Analytics' Leadership in setting the direction and establishing the technical approach for scaling and integrating the Enterprise Data Warehouse platform and associated information applications and programs.
• Build an Enterprise data warehousing solution with understanding of Data Modeling.
• Provide technical guidance with programming languages, particularly SQL, PL/SQL, Python, and for multiple database platforms such as Snowflake, Vertica, SQL Server, and MySQL.
• Participate and provide technical leadership in all phases of a project from discovery and planning through implementation and delivery.
• Work through all stages of a data solution life cycle: analyze/profile data, create conceptual, logical and physical data model designs, architect and design ETL, reporting and analytics solutions.
• Perform data analysis, data profiling, data cleansing, and data quality analysis in various layers using database queries in Big Data platforms.
• Perform data gap and impact analysis due to new data addition and existing data changes for new business requirements and enhancements.
• Mentor, advise, and coach team members in technical knowledge, practices, processes, and procedures.

Requirements

• Bachelor's degree (U.S. or foreign equivalent) in Computer Science or related field.
• Eight (8) years of experience in the job offered or related role.
• Seven (7) years of experience with Data warehouse, Data Modeling, and SQL.
• Five (5) years of experience with MPP databases including Vertica, Netezza, or Teradata.
• Four (4) years of experience with Snowflake, ETL tools, SQL Server, Oracle, and other on-premises databases like MySQL.

Qualifications

• Educational background in Computer Science or related field (implied by degree requirement).

Benefits & Perks

• Comprehensive healthcare (medical, dental, and vision) with premiums paid in full for employees and dependents.
• Retirement benefits such as a 401k plan and company match.
• Short and long-term disability coverage.
• Basic life insurance.
• Well-being benefits.
• Reimbursement for certain tuition expenses.
• Parental leave.
• Sick time of 1 hour per 30 hours worked.
• Vacation time up to 120 hours in the first year and 160 hours thereafter.
• Around 13 paid holidays per year.
• Employee stock purchase plan with discounted stock options.