2024-7257_Data Engineer - Level II

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.

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.

Essential RESPONSIBILITIES and ACCOUNTABILITIES

1. 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.
2. 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.
3. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives.
4. Manages engineering risks by proactively tracking and communicating issues, and devising methods to mitigating them.
5. Liaises with other project and program areas to coordinate interdependencies and resolve issues.
6. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA’s.
7. Maintains a working knowledge of new technology and software engineering standards, practices and tools.
8. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates
9. Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates

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

Knowledge & Skills:

1. Advanced knowledge of the theoretical and practical application of highly specialized software engineering best practices, methods & techniques.
2. Experience in developing software applications on the assigned technology platform.
3. Knowledge and experience using agile software development principles, process and tools..
4. Excellent analytical, problem solving and organizational skills.
5. Excellent interpersonal, and written and oral communication skills.
6. Strong customer service skills in order to provide end user/business owner systems support.
7. Knowledge of production support processes such as incident and problem management techniques.
8. Exposure to cloud computing such as snowflake would be ideal.
9. 5+ years’ experience with writing and debugging complex SQL queries
10. Must have the strong communication skills and ability to develop and present solutions to team and managers
11. Must be able to solve complex problems with direction.
12. Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required
13. Ability to establish and maintain positive working relationships with other employees

• 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.