Title: Data Reporting And Analytics Consultant Location: Pasadena United States Job Description: Description Job Summary In addition to the responsibilities listed below, this position is responsible for programming in analytical programming languages (may include Databricks, SQL, SPSS, R, Python, etc.), data management, and quality control support for a wide variety of projects under the supervision of more senior employees. The role oversees all phases of data management, quality control, and reporting, and defines analytical variables collaboratively with other researchers and statisticians. This position also performs analytical tasks using appropriate analytical tools; designs and generates tracking and data entry tools as needed; designs automated reporting and data loading schemes; develops comprehensive quality checking and validation processes; and designs troubleshooting software and programs. Essential Responsibilities Pursues self-development and effective working relationships by proactively providing resources, information, advice, and expertise to coworkers and customers. Influences others through technical explanations and examples, provides occasional mentoring, listens to and responds to feedback, creates plans to develop strengths and address weaknesses, anticipates the needs of others, and adapts to change and challenges. Completes work assignments by applying up-to-date subject matter expertise to generate creative solutions while ensuring adherence to procedures and policies. Leverages data and resources to support projects, collaborates cross-functionally to solve business problems, monitors priorities and deadlines, communicates progress, identifies improvement opportunities, and escalates issues or risks when appropriate. Supports and develops analytical and/or statistical models that enable informed business decisions by determining analytical requirements, creating models that produce actionable insights, and testing, refining, and validating those models. Gathers data and information on targeted variables using systematic methods, including validating data sources; querying, merging, and extracting data across multiple systems; completing routine data refreshes; developing tools for electronic data collection; and providing user training, support, and documentation. Supports interpretation of data analysis results by applying findings to real-world contexts under the guidance of senior staff, and develops reports and presentations that communicate insights clearly to stakeholders to support decision-making. Develops, implements, and automates business and reporting solutions in collaboration with stakeholders. Ensures consistency and coherency of solutions, summarizes data and results, creates summary statistics, organizes data reports and visualizations, develops interactive Business Intelligence (BI) reports, identifies the need for additional reporting solutions, and prepares supporting documentation. Prepares data for analytical use by consolidating data from multiple sources, reviewing for quality and accuracy, profiling data issues, cleaning datasets, and creating final datasets for analysis. Supports data-informed decision-making by consulting with clients to clarify business needs, developing outcome and process measures, translating business requirements into analytical plans, determining data collection methods, measuring the impact of business decisions, identifying opportunities to improve efficiency through analysis, supporting and training end users, and documenting processes and deliverables. Supports the execution of creative data analytic approaches by identifying metrics for analysis, calculating algorithms, and conducting analyses under senior guidance, including descriptive, correlational, inferential, and predictive statistics. Skills R, Python, Databricks, SQL, MPH Top Skills Details R,Python,Databricks,SQL,MPH Additional Skills & Qualifications Minimum Qualifications Minimum three (3) years of experience programming with Python, SQL, R, , or other similar analytical programming languages Minimum three (3) years of data management experience using Python, SQL, R, or similar tools Bachelor’s degree in Mathematics, Statistics, Engineering, Social Sciences, Physical/Life Sciences, Business, or a related field Minimum three (3) years of experience in data analytics or a directly related field Additional equivalent work experience may be substituted for the degree requirement Knowledge, Skills, and Abilities Data Integration SQL / SAS Web Report Studio Data Extraction and Data Mining Data Visualization Tools Statistical Programming Languages Relational Database Management Project Management Business Planning Written Communication Preferred Qualifications Two (2) years of health or medical research experience Two (2) years of experience working with SQL Two (2) years of experience working with open-source tools such as R or Python Master’s degree in Mathematics, Statistics, Engineering, Social/Physical/Life Sciences, Business, or a related field Experience Level Intermediate Level Job Type & Location This is a Contract position based out of Pasadena, CA. Pay and Benefits The pay range for this position is $35.00 - $40.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a fully remote position. About Actalent Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 20,000 consultants and 5,000 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500. We are proud to be an Engineering News-Record (ENR) Top 500 Design Firm for our engineering design services and a ClearlyRated Best of Staffing® winner for both client and talent service. The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records. Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.

• Design, build, and optimize robust data models within our central data warehouse (Snowflake) • Write and own complex, optimized SQL transformation logic using CTEs, window functions, and advanced joins • Lead the effort to integrate customer, revenue, and product usage identities across critical systems • Manage the performance and cost of our data warehouse including optimization of slow queries • Transform raw event-level data into intuitive, governed tables enabling analysts to use data confidently

• Manage day-to-day marketing automation operations—campaigns, forms, landing pages, and lead routing. • Maintain and evolve our marketing technology stack, ensuring clean integrations between CRM (Salesforce), automation tools (HubSpot/Marketo), and analytics. • Partner with demand gen, content, and product marketing teams to launch and optimize campaigns that move prospects through the funnel. • Design and maintain lead scoring and journey frameworks to ensure Sales gets high-quality leads with full context. • Build dashboards and reports that measure marketing performance, attribution, and ROI. • Explore and implement AI tools to accelerate campaign creation, personalization, and data management. • Serve as an internal expert on AI-enhanced workflows, championing new ways to work smarter and faster.

• Define and execute the enterprise Data, Analytics, AI, and Automation strategy • Develop and maintain a multi-year roadmap for data modernization • Advise executive leadership on emerging technologies, AI trends, opportunities, and risks • Manage enterprise data platform architecture, including the Enterprise Data Warehouse, Azure Data Lake • Establish enterprise data governance, data quality, and master data management capabilities • Develop enterprise analytics capabilities that improve decision-making • Drive adoption of intelligent automation and AI capabilities to improve productivity • Build, lead, and develop a high-performing organization