The Data Engineer II develops, implements, and maintains software solutions that enable business operations to realize company goals & objectives. The incumbent performs analysis, design, coding, debugging, testing, and support of software applications. May be assigned to develop new applications/systems, enhance/upgrade existing systems or provide production support. He/she works independently on moderately complex projects, receiving only general direction. May provide assistance and direction to less experienced peers.
Responsibilities
Essential RESPONSIBILITIES and ACCOUNTABILITIES
- Works with the Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately capture stakeholder requests and system specifications and translate them into engineering artifacts, which typically include design specifications, source code, test scripts and test results.
- As part of Agile teams, completes software development work which includes application design, coding, code review and testing. Keeps Agile team and APM apprised of project status.
- Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives.
- Manages engineering risks by proactively tracking and communicating issues, and devising methods to mitigating them.
- Liaises with other project and program areas to coordinate interdependencies and resolve issues.
- Supports business units in the resolution of in-depth user questions and issues following production support process and SLAโs.
- Maintains a working knowledge of new technology and software engineering standards, practices and tools.
- Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates
- Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates
Qualifications
JOB SPECIFICATIONS
Knowledge & Skills
- Advanced knowledge of the theoretical and practical application of highly specialized software engineering best practices, methods & techniques.
- Experience in developing software applications on the assigned technology platform.
- Knowledge and experience using agile software development principles, process and tools..
- Excellent analytical, problem solving and organizational skills.
- Excellent interpersonal, and written and oral communication skills.
- Strong customer service skills in order to provide end user/business owner systems support.
- Knowledge of production support processes such as incident and problem management techniques.
- Exposure to cloud computing such as snowflake would be ideal.
- 5+ yearsโ experience with writing and debugging complex SQL queries
- Must have the strong communication skills and ability to develop and present solutions to team and managers
- Must be able to solve complex problems with direction.
- Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required
- Ability to establish and maintain positive working relationships with other employees
Required Skills/Experience
Must Have
TSQL/PLSQL extensive knowledge to write, read and transform data MDX Multidimensional expressions using Stored Procedures
Snowflake/CDC anything like that re: Data virtualization and Warehousing tools. Cloud warehouse (data lake concepts)
ETL re: ODS and DDS
PowerBI requirement - service based or desktop based.
Nice to Have
SSISDB - Knowledge of SSIS/ADF - Migration of SSIS to ADF knowledge
Not needed
No database administration needed
Education
Education & Experience
Required knowledge and skills would typically be acquired through a Bachelors degree in computer science, business, or related field plus 7+ years of related experience.
The Company
Arch Global Services offers competitive pay and a comprehensive benefits package. Additionally, Arch is committed to helping its associates create whatโs next by providing access to a variety of programs supporting your professional development and a culture that encourages innovation, collaboration and professional growth. We seek talent that thinks innovatively, values collaboration and will go the extra mile to serve our customers and develop our company. We also have a little fun along the way, check out our Holiday Party.