Senior Data Engineer

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 View email address on click.appcast.io Reference Job Code: #AB0515.