Integration/Data Engineer

Job#: 3034728

Job Description:

Integration/Data Engineer (Databricks)

Project Overview: The Veterans Experience Office (VEO) leads VA's strategy to create meaningful Customer Experience (CX) between Veterans and VA employees across all VA channels. VA is focused on putting Veterans at the center of everything VA does and ensuring every interaction is predictable, consistent, and easy. As a result, VA is moving towards a unified approach grounded in the latest advanced analytics and AI methods to collect and analyze operational, experiential, social, behavioral, and enterprise data to support Veterans and their caregivers, dependents, survivors, and advocates.

VEO delivers critical milestones that further VA's commitment to deliver excellence, trust, and transparency to our Veteran community and plays a key role in delivering data-driven business processes, tools, and technological solutions. Our team is committed to supporting VEO in improving the insights derived from the vast amounts of Veteran and CX data, enhancing the platforms that operationalize that data and driving efficiency across all major VEO programs.

Scope of Work: The VA EMACS data, analytics, and AI teams accelerate action through data and insights to enhance the experiences of Veterans and their families, caregivers, survivors, and advocates through turning operational, experiential, social, behavioral, and enterprise data into insights for action and providing data, reporting, and analytics to stakeholders across VA. The team builds products and solutions from integrated data and transforms insights into Veteran impact, orchestrates coordinated responses, and optimizes experiences with AI and the latest data technologies. The team develops data engineering processes to ingest a variety of data sets (e.g., operational, experiential, social, behavioral, enterprise), integrates and aggregates for targeted use cases, and improves data and insights accessibility for enhanced decision-making. The team generates comprehensive reporting that drives strategic decisions and generates actionable insights across all levels of the organization. The team builds data, analytics, and AI products/solutions to enhance service delivery and optimize outcomes for Veterans and their families, caregivers, survivors, and advocates in VA priority areas, including homelessness, crisis, access to care, contact center, and additional use cases in alignment with VA/VEO priorities.

The Team: The VA EMACS data, analytics, and AI teams operate together to deliver data engineering, analytics, and AI solutions. The team is comprised of cross-functional resources who work together in an agile development process with two week-long sprint cycles. Team members are expected to be proactive, collaborative, and mission-focused in the development of enterprise solutions for users across VA.

Role: The VA EMACS team is looking for an Integration/Data Engineer to help optimize Veteran VA customer experience through data, analytics, advanced analytics, and AI tools and techniques in direct support of the Veterans Experience Office (VEO).

Position Responsibilities (including but not limited to):

• Build data engineering pipelines to support data ingestion, data conditioning/cleansing, and data integration/aggregation to enable use case and data product development.
• Configure data analytics processes to integrate data from various VA systems into Customer Experience Insights (CXI) data warehouse.
• Implement systems integration use cases to enable seamless data exchange among various VA systems.
• Engage with data scientists, data analysts, and data stewards to understand the functional and technical data integration and management requirements; develop technical specifications to illustrate/capture the requirements.
• Develop automated scripts for data extraction, conditioning, and integration of large data sets into actionable insights for informed client decision-making - and maintain developed models.
• Support ad-hoc data analytics requests by quickly understanding requirements and mapping those requirements to data attributes; deliver ad-hoc data reports based on client reporting specifications.
• Support data analytic product capabilities by studying information needs specific to the client; conferring with users; and following a hybrid agile software development lifecycle.

Required Qualifications:

• Must have experience with Databricks as it relates to data engineering. Databricks is the primary platform they will be using for ETL/Data Warehousing and this role requires Databricks development expertise.
• 1+ years of experience in Python/Spark programming for implementing data operations such as connectivity, data manipulation, data integration and publication.
• 1+ years of experience in SQL or related query languages.
• 1+ years of experience developing ETL pipelines and troubleshooting data load issues.
• 1+ years of experience in Databricks for data engineering, systems integration, or machine learning projects.
• 1+ years' experience in data warehousing projects and understanding of implementation of dimensional modelling concepts such as fact and dimension tables.
• 1+ years of experience working with GitHub for code management and deployment.
• 1+ years of experience working with Agile development frameworks.
• 1+ years of prior experience with data analytics with at least 2+ years of experience working in an IT environment.
• 1+ years of prior consulting experience.
• 1+ years of prior work experience in or with the Federal government.
• Ability to quickly adapt and excel in a fast-paced environment.
• Experience working with Microsoft Word, PowerPoint, Excel, and Visio.
• Strong organizational and collaboration skills.
• Strong written and verbal communication skills to support business writing, reporting, team and client collaboration, and professional correspondence.
• Must hold a minimum of a bachelor's degree.

Preferred Qualifications:

• 3+ years of prior experience working in data and analytics environments.
• 3+ years of experience with data engineering and ETL development.
• 2+ years of experience in Azure cloud services (e.g., Synapse, Containers, ADF, Azure DevOps).
• 1+ years of experience developing data analytics products e.g., Power BI.
• 1+ years of prior experience in healthcare environments/clients.
• Experience with systems integrations e.g., API integrations.
• Experience with VA systems e.g., CX Insights, Lighthouse APIs, Medallia.
• Experience in/familiar with Jira.
• Strong organizational and management skills.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth 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. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.

Everforth Apex Benefits Overview: Everforth 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. Everforth 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, Everforth 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. Everforth 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 Everforth Apex team member can provide.