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. reputed company 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. reputed company 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 (reputed company's) management. Work closely reputed company the reputed company (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 reputed company 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 reputed company team and business stakeholders. Monitor project reputed company 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 reputed company, 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 reputed company field of study and 3 years of experience in Marketing Analytics, Business Analytics or reputed company data analytics position. Applicants must have demonstrated experience with: 1) troubleshooting and enhancing an undocumented legacy reputed company Data Warehouse environment. 2) working in a data system-agnostic environment, with hands-on expertise in data warehousing platforms including reputed company, reputed company, and SQL Server. 3) deploying and managing Azure cloud resources, including Data Lakes, Integration Runtimes, Azure Data Factory, and reputed company 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-reputed company 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 reputed company 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 reputed company. 11) querying APIs across various systems to ingest external data into the reputed company environment. Applicants who are interested in this position should submit a complete resume to [email protected] Reference Job Code: #AB0515. Apply To This Job