NAME OF EMPLOYER: PTZ Insurance Agency Ltd.
POSITION TITLE: Sr. Data Engineer
HOURS: Full Time/40 hours
JOB DUTIES: Collaborate with business stakeholders to understand business strategy and needs, anticipate requirements, uncovering areas for improvement and implementing solutions. Conduct thorough analysis of requests to assess feasibility, impact and alignment with strategic goals. Perform detailed requirements analysis, including definition of objectives, scope, business value and success criteria. Create clear and concise requests and project documentation, such as business cases and plans, to guide project scoping and decision-making. Facilitate prioritization sessions with key stakeholders, including senior marketing team members (L2 and L3), to evaluate and rank requests based on business value, urgency and available resources. Develop and maintain strong relationships with stakeholders to understand needs, gather feedback and ensure alignment between business objectives and analytics initiatives. Communicate project priorities and timelines effectively to cross-functional teams, including data and Bl analysts as well as business and Enterprise Data Office’s (EDO's) management. Work closely within the EDO (including Data Engineers, Data Analysts, Developers and Bl Analysts) to define deliverables, create data requirements and define or recommend analytical methodologies. Provide guidance and support to EDO pods throughout development cycle, ensuring they have necessary resources and information to deliver high-quality results. Review and validate analytical outputs, ensuring accuracy, consistency and alignment with business requirements. Serve as a liaison between EDO team and business stakeholders. Monitor project progress and timelines using Azure DevOps and PowerBI, proactively identifying and addressing potential roadblocks or delays. Prepare regular project status reports and communicate updates to stakeholders, keeping them informed of progress, achievements and challenges. Conduct post-delivery evaluations to assess performance, identifying areas for improvement and capturing lessons learned for future initiatives.
Position offered by PTZ Insurance Agency Ltd.
POSITION LOCATION: 100% remote reporting to: 11333 N Scottsdale Rd., Suite 160, Scottsdale, AZ 85254
REQUIREMENTS: Bachelor’s degree or equivalent in Computer Science, Information Systems/Technology, Computer Engineering, Business Analytics, Management Information Systems or related field of study and 3 years of experience in Marketing Analytics, Business Analytics or related data analytics position.
Applicants must have demonstrated experience with:
1) troubleshooting and enhancing an undocumented legacy Snowflake Data Warehouse environment.
2) working in a data system-agnostic environment, with hands-on expertise in data warehousing platforms including Snowflake, Databricks, and SQL Server.
3) deploying and managing Azure cloud resources, including Data Lakes, Integration Runtimes, Azure Data Factory, and related services.
4) domain-specific data modeling approaches to model data tables tailored to the pet insurance industry (i.e. lacks standardized schemas).
5) designing and implementing scalable, metadata-driven, multi-source Azure Data Factory pipelines that connect to diverse data sources across multiple cloud tenants.
6) maintaining and updating SSIS packages based on business logic and use cases, including environments with minimal documentation.
7) building Azure Functions and Logic Apps to ingest data from irregular sources.
8) dbt core, including developing, deploying, and operationalizing code that processes thousands of tables within an enterprise data warehouse.
9) development practices using Visual Studio Code, including branching strategies, code merging, and managing interdependent projects across multiple repositories.
10) Azure DevOps release pipelines, including creating, troubleshooting, and modifying pipelines for code deployment, automated testing, and documentation generation.
11) querying APIs across various systems to ingest external data into the Snowflake environment.
Applicants who are interested in this position should submit a complete resume to [email protected] Reference Job Code: #AB0515.
Skills Required
- Bachelor's degree or equivalent in Computer Science, Information Systems/Technology, Computer Engineering, Business Analytics, Management Information Systems or related field and 3 years of experience in Marketing Analytics, Business Analytics or related data analytics position.
- Troubleshooting and enhancing an undocumented legacy Snowflake Data Warehouse environment.
- Hands-on expertise in data warehousing platforms including Snowflake, Databricks, and SQL Server.
- Deploying and managing Azure cloud resources, including Data Lakes, Integration Runtimes, and Azure Data Factory.
- Applying domain-specific data modeling approaches tailored to the pet insurance industry.
- Designing and implementing scalable, metadata-driven, multi-source Azure Data Factory pipelines across multiple cloud tenants.
- Maintaining and updating SSIS packages based on business logic in minimally documented environments.
- Building Azure Functions and Logic Apps to ingest data from irregular sources.
- dbt core experience: developing, deploying, and operationalizing code that processes thousands of tables within an enterprise data warehouse.
- Development practices using Visual Studio Code, including branching strategies, code merging, and managing interdependent projects across multiple repositories.
- Azure DevOps release pipelines experience for creating, troubleshooting, and modifying pipelines for code deployment, automated testing, and documentation generation.
- Querying APIs across various systems to ingest external data into the Snowflake environment.
Independence Pet Holdings Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Independence Pet Holdings and has not been reviewed or approved by Independence Pet Holdings.
-
Healthcare Strength — Comprehensive medical, dental, and vision coverage is described alongside company-paid life insurance and disability coverage. HSA/FSA options and an Employee Assistance Program add additional health and protection support.
-
Parental & Family Support — Twelve weeks of 100% paid parental leave is explicitly offered. This level of fully paid leave is positioned as a meaningful family-support benefit.
-
Leave & Time Off Breadth — Personal paid time off is paired with 10 holidays and a company-wide Wellness Day. Paid time off to volunteer also expands time-off options beyond standard PTO.
Independence Pet Holdings Insights
What We Do
Established in 2021, Independence Pet Holdings is a corporate holding company that manages a diverse and broad portfolio of modern pet health brands and services across insurance, pet education, lost recovery services, and beyond across North America. As a leading authority in the industry, we operate with a full stack of resources, capital, and services that support a multi-brand and omni-channel approach. We operate our own insurance carrier and partner successfully with other carriers, as needed. We believe that pet insurance is more than a financial product and build solutions to simplify the pet parenting journey and help improve the well-being of pets
