Senior Data Engineer
About The Position
PTZ Insurance Agency Ltd. is seeking a Sr. Data Engineer to collaborate with business stakeholders, understand business strategy and needs, and implement solutions. This role involves conducting thorough analysis of requests, performing detailed requirements analysis, and creating project documentation. The Sr. Data Engineer will facilitate prioritization sessions, develop strong relationships with stakeholders, and communicate project priorities effectively to cross-functional teams. This position involves working closely within the Enterprise Data Office (EDO) to define deliverables, create data requirements, and recommend analytical methodologies. The role also includes 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.
- Demonstrated experience with troubleshooting and enhancing an undocumented legacy Snowflake Data Warehouse environment.
- Demonstrated experience working in a data system-agnostic environment, with hands-on expertise in data warehousing platforms including Snowflake, Databricks, and SQL Server.
- Demonstrated experience deploying and managing Azure cloud resources, including Data Lakes, Integration Runtimes, Azure Data Factory, and related services.
- Demonstrated experience with domain-specific data modeling approaches to model data tables tailored to the pet insurance industry (i.e. lacks standardized schemas).
- Demonstrated experience designing and implementing scalable, metadata-driven, multi-source Azure Data Factory pipelines that connect to diverse data sources across multiple cloud tenants.
- Demonstrated experience maintaining and updating SSIS packages based on business logic and use cases, including environments with minimal documentation.
- Demonstrated experience building Azure Functions and Logic Apps to ingest data from irregular sources.
- Demonstrated experience with dbt core, including developing, deploying, and operationalizing code that processes thousands of tables within an enterprise data warehouse.
- Demonstrated experience with development practices using Visual Studio Code, including branching strategies, code merging, and managing interdependent projects across multiple repositories.
- Demonstrated experience with Azure DevOps release pipelines, including creating, troubleshooting, and modifying pipelines for code deployment, automated testing, and documentation generation.
- Demonstrated experience 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
