Senior Data Engineer

Independence Pet Group • Scottsdale, AZ

6d • Remote

About The Position

PTZ Insurance Agency Ltd. is seeking a Sr. Data Engineer to collaborate with business stakeholders, understand business strategy and needs, anticipate requirements, and identify areas for improvement. The role involves conducting thorough analysis of requests to assess feasibility, impact, and alignment with strategic goals, as well as performing detailed requirements analysis. The Sr. Data Engineer will create project documentation, facilitate prioritization sessions, and develop strong relationships with stakeholders. This position will work closely within the Enterprise Data Office (EDO) to define deliverables, create data requirements, and recommend analytical methodologies. The role also involves providing guidance and support to EDO pods, reviewing and validating analytical outputs, and serving as a liaison between the EDO team and business stakeholders. Monitoring project progress using Azure DevOps and PowerBI, preparing status reports, and conducting post-delivery evaluations are also key responsibilities.

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.
• Troubleshooting and enhancing an undocumented legacy Snowflake Data Warehouse environment.
• Working in a data system-agnostic environment, with hands-on expertise in data warehousing platforms including Snowflake, Databricks, and SQL Server.
• Deploying and managing Azure cloud resources, including Data Lakes, Integration Runtimes, Azure Data Factory, and related services.
• Domain-specific data modeling approaches to model data tables tailored to the pet insurance industry (i.e. lacks standardized schemas).
• Designing and implementing scalable, metadata-driven, multi-source Azure Data Factory pipelines that connect to diverse data sources across multiple cloud tenants.
• Maintaining and updating SSIS packages based on business logic and use cases, including environments with minimal documentation.
• Building Azure Functions and Logic Apps to ingest data from irregular sources.
• dbt core, including 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, including 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.

Responsibilities

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior