Sr. ETL / BI Developer

Job#: 3018361

Job Description:

Position Details

The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications located on the client's Teradata Data Warehouse platform. The position will represent the team and coordinate team activities with other data warehouse teams on complex, multi-team projects. In addition, the position will work with other data warehouse developers to review existing data warehouse policies and practices, modify them as needed, or propose new polices or practices.

Knowledge of SQL, Business Intelligence tools, and experience with the relational database is required to help develop and maintain data warehouse ETL and queries.

CANDIDATES WILL BE EVALUATED ON THE FOLLOWING CRITERIA:

Required Skills:

Bachelor's degree or equivalent technical study

6+ Years Creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery system.

2+ Years Child Welfare Services, Juvenile Justice, Juvenile services, or other related experience

Additional Skills:

Experience with PMM/SUITE/Agile methodology

SQL Assistant/Teradata Studio Experience, BI applications

End user training experience

Must be able to work independently with little directions

Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector.

Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan.

Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations.

Experience working with Data Modelers and developers, facilitating modification of the logical design to create a physical design most suited to the reporting needs of the customer.

Ability to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value.

With the Business Analyst, presents the information gathered to the Project Review Board and/or Project Sponsors during project review meetings, project workgroups and to the Technical Review Board providing clarification and answers to questions.

Consult with agency clients to explain complex IT processes and solutions, developing and maintaining an effective communication plan with agency clients relating to project level metrics, bureau level project reporting, etc.

Assist Architect or DBA to draft technical database model that:

o Complies with audit separation of duty requirement.

o Captures requirements of data elements

o Designs data elements to best meet application needs

o Reviews and approves updates to systems documentation.

Gather, review, and analyze potential impacts of changes and inform management and supported client agency of impact and risks to existing IT solutions due to proposed legislation, enhancement requests, changes in government requests, changes in governmental processes or procedures.

Provide professional technical expertise to the Managers and client agency managers and supervisors in IT project estimating, and budgeting.

Serves as a team lead and resource, directing the code development, providing advice and guidance to other development staff.

Evaluate and identify opportunities for programming process or tools standardization.

Perform disaster recovery planning and implementation.

Provide input to procedures and ensure proper change management for all requested fixes to production systems.

Review and approve test plans. Incorporate all levels of security, which were identified as system requirements, into test plans.

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.