Business Analyst - Data Engineer II

Job#: 3022011

Job Description:

Job Title: Data Engineer II

Location: Cincinnati, OH (Onsite)

Pay: $60-$65

Length: 9 months

Job Description

Data Engineer / Business Analyst

Position Overview

The Data Engineer / Business Analyst is responsible for designing and implementing solutions that enable the organization to manage, secure, and derive value from its data assets. This role develops scalable, reusable data solutions for collecting, storing, processing, and delivering data across both traditional and large-scale (Big Data) environments. Solutions may span on-premises and cloud platforms and include work across ETL, business intelligence, analytics, data warehousing, data lakes, search, messaging, and machine learning.

The individual in this role is accountable for adhering to organizational policies, managing risk appropriately, and supporting a positive customer and colleague experience. Operating within the Bank's risk appetite, the Data Engineer / Business Analyst consistently identifies, assesses, manages, and reports risks of all types.

Essential Duties and Responsibilities

• Work independently to engage with business partners, gather requirements, and translate them into clear, actionable functional designs.
• Collaborate with technical team members to communicate business requirements and support the development of appropriate technical solutions.
• Develop clear and complete test acceptance criteria; perform unit testing and user acceptance testing to validate solution accuracy.
• Create and execute SQL scripts to support ETL processes and data validation.
• Conduct research and development on emerging technologies, industry trends, data engineering practices, and data security topics relevant to the banking sector.
• Build and maintain CI/CD pipelines, self-service build tools, and automated deployment processes.
• Evaluate software products and provide documented recommendations.
• Provide support and troubleshooting for data platforms, including participation in escalated on-call support for complex or critical incidents.
• Contribute to internal initiatives such as legacy system replacement, monitoring and analytics enhancements, tool development, and technical documentation.
• Offer guidance and mentorship to team members.
• Manage and prioritize multiple assignments effectively.

Supervisory Responsibilities

None

Required Skills

• Power BI
• Strong analytical capabilities
• SQL (3-5 years of experience)
• Excellent communication skills
• Ability to lead and facilitate meetings
• Strong problem-solving and critical-thinking skills

Preferred Skills / Experience

• DataStage

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Systems, or an equivalent combination of education and experience.
• Strong verbal and written communication skills, with the ability to tailor messaging to management, business stakeholders, and technical teams.
• Excellent analytical and problem-solving abilities, particularly in resolving data-related issues and designing new solutions.
• Technical proficiency in SQL (3-5 years), DataStage (ETL), DBT, Snowflake, and Python.
• Conceptual understanding of one or more of the following:
  • Big data technologies and distributions
  • Metadata management tools
  • Commercial ETL platforms
  • Data visualization and reporting tools
  • Data warehousing
  • Data testing
  • Major cloud platforms
  • REST API design and development
• Experience with SDLC methodologies and the ability to support project management activities, including release management and implementation tasks.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Apex uses a virtual recruiter as part of the application process. Click for more details.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.