Data Engineer II

Overview

This position is based in our Phoenix, AZ Support Office. The Data Engineer II will work on all phases of the software development lifecycle supporting a variety of projects and applications. This role will be a mid-level position, with an expectation of continuing to build technical skills with increasingly more complexity and responsibility on projects. Candidates for this position will have prior experience delivering efficient, secure, high performance, and easy-to-support solutions primarily within the Microsoft suite of technologies.

Overview of Responsibilities

• Analyze, fix, and test production support tickets for a variety of systems
• Build ETL which loads complex data warehouse objects including dimensions, hierarchies, fact tables, and aggregates
• Provide clear and concise explanation and interpretation of the business needs to reach agreement and ensure understanding of needs
• Work with a cross functional team to understand the business issues or identify opportunities and gather Design and system requirements
• Build and deploy customer facing Bl solutions (Analysis cubes, Power BI) and build the reporting metadata layer
• Develop and support data marts and cubes to support functional area data consumers
• Support and create data pipelines
• Gather, analyze, and document user reporting and/or data feed requirements
• Provide escalated support for junior team members
• Perform any other assigned tasks deemed necessary by management

Qualifications

Knowledge, Skills and Abilities:

• Bachelor's degree in Computer Science or equivalent work experience
• 3+ years of experience with Microsoft SQL and Microsoft Azure technologies including Power BI
• 1+ years of experience with Azure Data Lake and Informatica
• Strong verbal and written communication skills, analytical and decision-making skills, and ability to work on cross-functional teams
• Solid understanding and usage of source control solutions
• Change and release management skills
• Requirements gathering and documentation skills

Technical Skills:

• Databases - MS SQL Server
• Tools - Visual Studio, SQL Server Management Studio, Azure DevOps, Redgate, Power BI, Azure Data Lake, Azure API Gateway, Informatica
• Languages - SQL, DAX, PowerShell
• Other - SharePoint, Microsoft Office Suite, Visio

Core Competencies:

• Communication: Convey information, ideas, and feedback clearly and concisely in an engaging manner that helps others understand and retain the message; listening actively to others.
• Customer Focus: Place a high priority on the customer's perspective when making decisions and taking action; implementing service practices that meet the customers' and own organization's needs.
• Driving for Results: Set SMART goals and measure progress; tenaciously working to meet or exceed goals and making continuous improvement. Seeking innovative ways to solve problems that result in unique and differentiated solutions.
• Positive Approach: Demonstrate a positive attitude in the face of difficult or challenging situations; provide an uplifting (yet realistic) outlook on what the future holds and the opportunities it might present.