Technical Business Analyst
About the role
We are seeking a Technical Business Analyst to serve as the critical bridge between business stakeholders and data modeling teams supporting a large-scale enterprise data platform initiative. This role is embedded onsite to enable active, ongoing collaboration with business stakeholders, gathering and translating their requirements into clear, technical specifications that data modelers can execute against within a modern Lakehouse environment.
Responsibilities
- Partner directly with business stakeholders onsite to understand business processes, data needs, reporting requirements, and analytical use cases across multiple product domains.
- Translate business requirements into clear, structured technical specifications, source-to-target mappings, and modeling requirements that data modelers can execute against.
- Analyze source system data and structures, working alongside domain experts to understand relationships, entities, and business rules across a large landscape of source tables.
- Cross-functional Collaboration: Act as the connective tissue between business stakeholders, data modelers, and platform teams, ensuring alignment on definitions, priorities, and deliverables.
- Data Modeling Support: Leverage working knowledge of dbt and SQL to validate transformations, review models, and ensure the delivered data products meet business requirements.
- Create and maintain comprehensive documentation of business requirements, data definitions, business rules, source-to-target mappings, and modeling specifications.
- Support data validation and quality efforts, partnering with modelers to confirm that gold-layer data products accurately reflect business needs.
Requirements
- 5+ years of experience as a Business Analyst, Data Analyst, or Technical Analyst supporting data or analytics initiatives.
- Hands-on proficiency with SQL for data analysis, validation, and requirements definition.
- Working knowledge of dbt (data build tool) and the ability to understand and interpret data transformations.
- Strong understanding of modern data modeling concepts, including dimensional modeling and medallion/Lakehouse architecture (bronze, silver, gold layers).
- Prior experience with project controls, field management, or construction/engineering domain data (or similar complex operational domains).
- Experience supporting data platform build-outs or medallion architecture initiatives.
- Experience with ERP or enterprise operational systems and integrating their data into analytics platforms.
- Experience working in Agile delivery environments.
- Experience with data quality frameworks and validation practices.
Qualifications
- Comfortable working onsite and driving active, in-person collaboration with business stakeholders.
- Highly organized with strong documentation skills and attention to detail.
- Ability to manage multiple priorities and navigate ambiguity in a fast-moving environment.
Benefits
Competitive compensation and a collaborative, high-impact team environment. 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.