> Markdown version of [/jobs/ext/1572638-senior-data-analyst-data-engineer](https://www.wearedevelopers.com/jobs/ext/1572638-senior-data-analyst-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Analyst / Data Engineer - **Company:** Insight Global - **Location:** Oakland, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Spreadsheets, Databases, Data Cleansing, Information Engineering, Data Transformation, Data Profiling, Python (Programming Language), SQL Databases, Data Processing, Powerquery - **Published:** July 8, 2026 - **Apply:** https://dejobs.org/x/x/E46D82DD2BEF44A8BF0A5E09A6086437/job/ ## About the Role This role is best suited for a hands-on resource with strong experience in data wrangling, structured file comparison, data quality analysis, and repeatable transformation execution, ideally within engineering, industrial, or utility data environments. Key Skills Data profiling and analysis File comparison and reconciliation Data cleansing and transformation Structured problem solving Exception identification and documentation Python / SQL / Excel-based data handling Quality control and auditability Attention to detail Ability to execute repeatable processing with consistency Clear technical documentation Ideal Candidate Profile The ideal candidate is a strong hands-on data specialist who can work through complex file structures, identify patterns and mismatches, and execute a repeatable transformation process with high accuracy. They should be comfortable operating in a partially defined environment, where discovery and iteration are required before the final approach is fully established., 5+ years of experience in: Data analysis Data engineering Data transformation/preparation Data quality analysis Engineering or industrial data support Experience working with large structured datasets in flat files, spreadsheets, CSVs, or database extracts. Experience identifying and reconciling data discrepancies across multiple source files. Experience performing repeatable data transformations and documenting assumptions/logic. Strong working knowledge of tools such as: Python SQL Excel / Power Query Similar data manipulation tools Experience supporting validation, exception handling, and output quality review. Experience with: Pipeline inspection data Pipe tally records EMAT or in-line inspection datasets Engineering asset or inspection data Utility, energy, or industrial operations datasets Exposure to data correlation problems involving distance-based or linear asset records. Experience supporting data preparation for database integration or enterprise platforms. Familiarity with working in environments where source data lacks standardization or formal documentation. ## Description The Senior Data Analyst / Data Engineer will support the analysis, transformation, correlation, and standardization of EMAT and standard ILI pipe tally datasets across approximately. This resource will work under the direction of the Technical Lead to profile data, execute matching and transformation logic, identify exceptions, and produce validated outputs in a consistent, auditable format for client use. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Launching a marketplace on-time: A lesson in taking shortcuts using spreadsheets!](https://www.wearedevelopers.com/videos/477-launching-a-marketplace-on-time-a-lesson-in-taking-shortcuts-using-spreadsheets) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)