Title: Data Investigator #2793 Location: Dallas, Texas Job Description: Data Investigator (Python, SQL, Tableau Focus) Contract Length: 12 months + potential extension Location: Dallas, Texas – Hybrid (3 days onsite, downtown Dallas) Our client is seeking a Data Investigator to support their Advanced Metering System (AMS) operations through advanced data analysis, troubleshooting, and insight generation. The ideal candidate will leverage Python, SQL, and Tableau to query, clean, and visualize complex datasets—identifying patterns, correlations, and root causes that drive operational improvements and business decisions. This position involves working with meter asset, communication, energy, event, and customer service data to deliver data-driven insights and performance reporting. You’ll collaborate with cross-functional teams to troubleshoot data discrepancies, enhance data pipelines, and develop dashboards that bring clarity to large-scale operational systems. Qualifications - Associate’s, Bachelor’s, or Master’s degree in Computer Science, Data Science, Engineering, Statistics, or related field. - 7+ years of professional experience in data analysis, data investigation, or business analytics. - Strong proficiency in Python, including libraries such as pandas, NumPy, matplotlib, and seaborn for data analysis and visualization. - Advanced SQL skills for querying, joining, and troubleshooting data across multiple relational databases. - Proven experience building interactive dashboards and reports in Tableau (Power BI experience is a plus). - Demonstrated ability to identify trends, correlations, and root causes within large datasets. - Familiarity with statistical techniques and pattern recognition methods for anomaly detection or performance monitoring. - Experience in data troubleshooting, pipeline validation, and data quality improvement. - Excellent problem-solving skills and the ability to communicate complex analytical findings to non-technical audiences. - Experience with Agile methodologies, collaborative tools, and process documentation. Key Responsibilities - Use Python for data extraction, troubleshooting, cleaning, and process automation. - Write and optimize SQL queries across multiple databases to retrieve, manipulate, and validate AMS-related data. - Develop and maintain Tableau dashboards and visualizations to surface key performance trends, correlations, and anomalies. - Identify and interpret patterns and relationships within large, complex datasets to support root-cause analysis and operational improvements. - Analyze meter processes, system synchronization, and data quality between systems such as CIS, AMS, and mobile workforce platforms. - Collaborate with stakeholders to refine data collection and improve the accuracy and reliability of reporting. - Troubleshoot and validate data issues, recommending process improvements or corrective actions. - Document analytical methodologies, SQL logic, and Python workflows for knowledge sharing and reproducibility. - Contribute to continuous improvement initiatives through automation, data integration, and enhanced analytical capability. Genius Road, LLC is proud to be a Certified Women’s Business Enterprise, an Equal Opportunity Employer and values diversity. All employment is decided on the basis of qualifications, merit and business need.

• Oversees a team of business analysts, ensuring the delivery of accurate and timely data insights • Provides oversight to key stakeholders regarding data-centric activities, tools, and technologies • Recruits and manages a team of data analysts, acting as a coach and mentor • Manages Decision Science projects and adhoc requests • Ensures timely and accurate submission of required data reporting • Collaborates with technology leaders, business partners, and peer groups • Creates and builds dashboards and automated reporting solutions • Assists in data migration, conversion, and data validation activities

• Gather, organize, and document program, operational, and business requirements from stakeholders across the ecosystem. • Develop and maintain SOPs, workflows, process maps, onboarding materials, and PMO templates. • Standardize documentation practices across multiple entities and project teams. • Validate data inputs before information is distributed to program leadership. • Ensure consistency and accuracy across dashboards, reports, metrics, and status updates. • Maintain data dictionaries and reporting standards to ensure common definitions across all stakeholders. • Support Program Managers and Project Managers with reporting, documentation, meeting preparation, and analysis. • Identify process inefficiencies, reporting challenges, and documentation gaps.

• Lead client engagements by translating complex data into actionable insights that support strategic decision-making and business outcomes • Design, oversee, and execute analytics initiatives involving structured and unstructured data using modern analytical techniques. • Manage projects from requirements gathering through implementation while maintaining scope, budget, timelines, and stakeholder communication • Lead or support deployment of software, automation, and analytics solutions within enterprise environments and modern cloud platforms • Partner with stakeholders across finance, accounting, FP&A, operations, and technology functions to deliver cross-functional solutions • Advise clients on data governance, data quality, security considerations, and sustainable operating models that encourage enterprise adoption • Evaluate emerging technologies, including AI-enabled analytics and automation capabilities, that can improve client outcomes • Mentor and develop team members while promoting continuous learning and adoption of emerging technologies • Support recruiting, talent development, and team-building initiatives • Drive business development through relationship building, opportunity identification, and proposal development • Communicate complex technical concepts effectively to technical and non-technical audiences