Senior Technical Business Analyst

Pacer Group; Denver (CO); Hybrid; USD 70,000 - 85,000; Part time

Benefits offered by this job

Medical

Dental

Vision

401(k)

Job summary

Pacer Group in Denver, CO, is seeking a Senior Technical Business Analyst for a 6+ month contract to solve data-intensive challenges. You will analyze requirements, design scalable relational and non-relational schemas, and support ETL and Spark pipelines.

The role sits in Enterprise Data Solutions, reporting to the Director of Data Management, collaborating with infra and apps teams to ensure data availability and analytics that meet regulatory expectations.

Qualifications

• Must-have: strong SQL, Spark skills and data modeling for complex data stores.
• Experience designing relational and non-relational schemas for analytics.
• Knowledge of ETL pipelines and data quality practices.

Responsibilities

• Analyze complex data flows to define requirements for scalable data solutions.
• Translate requirements into logical and physical data models for analytics.
• Coordinate database installation with infra and apps teams for stability.
• Develop and optimize SQL queries and ETL/Spark workflows.
• Perform data validation and root-cause analysis with stakeholder docs.

Skills

Apache Spark

Advanced SQL & Query Optimization

Relational & NoSQL Databases

Education

CBAP

Azure Data Engineer Associate or equivalent

Job description

Job Title: Senior Technical Business Analyst

Work Arrangement: Hybrid (4 days in office)

Employment Type: Contract

Duration: 6+ Months

Domain: Enterprise Data Solutions & Business Analytics

Pay Rate: $51.00/hr W2 | $62.00/hr C2C

Application Deadline: September 25, 2026

SKILLS REQUIRED

Primary (Must-Have)

• Apache Spark | Advanced SQL & Query Optimization | Relational & NoSQL Databases

Secondary (Good to Have)

• Business Analysis Certifications (CBAP)
• Cloud Data Credentials (Microsoft Azure Data Engineer Associate or equivalent)

POSITION OVERVIEW

This role sits within the Enterprise Data Solutions department, reporting directly to the Director of Data Management. The incumbent will solve complex data-intensive solution delivery challenges for the client by analyzing business requirements, designing robust relational and non-relational database schemas, and supporting scalable ETL and Spark pipelines.

ROLES & RESPONSIBILITIES

• Analyze complex business processes and data flows to define detailed requirements that guide the design of scalable data solutions aligned with enterprise objectives and regulatory expectations.
• Translate business requirements into logical and physical data models, designing and refining relational and non-relational database schemas to support reporting and analytics.
• Coordinate end-to-end database installation activities by collaborating with infrastructure and application teams to ensure stable environments and reliable data availability.
• Develop and optimize SQL queries, views, and stored logic, alongside defining and validating robust ETL workflows and Spark-based data processing techniques.
• Conduct data validation, reconciliation, and root-cause analysis to protect analytical accuracy while providing ongoing support and technical documentation for stakeholders.

BENEFITS

Medical | Dental | Vision | 401(k)

EEOC Compliance:

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment.

DISCLAIMER

AI Usage Policy: Pacer Group uses AI to assist in screening applications. Final hiring decisions are made by human recruiters based on qualifications and experience.