Data Analyst

Data Analyst Location: Oklahoma City, OK (onsite 5 days/week) Industry: Transportation / Infrastructure Contract: 6 month with extension Pay: $37-40/hr Position available: Now-July 10 Brooksource is seeking a Data /Business Analyst to support a leading organization within the transportation and infrastructure industry. This role is ideal for someone who thrives at the intersection of data analysis, SQL development, and business process improvement. You’ll work with complex datasets and systems to uncover data integrity issues, identify root causes, and deliver insights that drive business decisions. This is a great opportunity for a self-starter who enjoys digging into data, learning new systems, and partnering with stakeholders to improve reporting accuracy and operational efficiency. Key Responsibilities • Analyze large and complex data sets to identify trends, anomalies, and data integrity issues. • Investigate root causes and provide actionable recommendations to improve data quality. • Write, modify, and optimize SQL queries and stored procedures to support reporting needs. • Develop and maintain reports, dashboards, and ad hoc analyses for business stakeholders. • Review existing code, reports, and performance metrics to identify and resolve defects. • Document business processes, workflows, and system behaviors. • Partner with stakeholders to identify and implement process improvement opportunities. • Conduct data quality assessments and ensure accuracy across systems. • Learn and support internal systems, workflows, and backend SQL procedures. Required Qualifications: • 3+ years of experience as a Data Analyst or Business Analyst. • 2+ years of hands-on experience with SQL development (queries, functions, stored procedures). • Strong understanding of data modeling, database design, and data mining techniques. • Experience documenting business processes and workflows. • Proficiency with tools such as: Microsoft SQL Server / SSMS, Power BI or similar reporting tools, Data formats such as XML and JSON. • Strong analytical mindset with attention to data accuracy and detail. • Ability to translate data findings into clear, actionable insights. • Excellent communication skills and ability to work with cross-functional teams. Preferred Qualifications: • Experience working with Google Cloud Platform (GCP), especially dashboards. • Exposure to Six Sigma or process improvement methodologies. • Background in software development. Soft Skills & Work Style: • Self-driven and comfortable working both independently and collaboratively. • Strong problem-solving and critical thinking skills. • Ability to manage changing priorities and multiple tasks. • Effective communicator with the ability to engage both technical and non-technical stakeholders. Additional Requirements • Must be able to pass background and vehicle checks EEO Statement: Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.