> Markdown version of [/jobs/ext/1891926-data-engineer](https://www.wearedevelopers.com/jobs/ext/1891926-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). --- # Data Engineer - **Company:** OP Consulting Group LLC - **Location:** United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Data Analysis, Information Engineering, Data Transformation, Data Systems, Operational Data Store, Power BI, SQL Databases, Systems Integration, Freeform SQL, Information Technology, Data Analytics - **Published:** August 1, 2026 - **Apply:** https://www.dice.com/job-detail/d63b45ed-efdd-40f1-a12b-ad8384d1dbb1 ## About the Role The selected candidate must possess: * A minimum of three years, preferably four to seven years, of professional experience in data engineering, business intelligence, data analytics, or a related information technology discipline. * Demonstrated experience designing, developing, implementing, and maintaining enterprise reporting and business intelligence solutions. * Experience integrating, transforming, and analyzing data from multiple enterprise systems using SQL and modern data engineering techniques. * Experience developing interactive dashboards, scorecards, and executive reports using Microsoft Power BI or a comparable business intelligence platform. ## Description The Senior Data Engineer will perform duties including, but not limited to, the following: Portfolio Reporting and Business Intelligence * Design, develop, implement, and maintain enterprise dashboards, executive scorecards, and business intelligence solutions supporting IT investment management. * Develop standardized portfolio reporting to support IT investments, project performance, portfolio governance, and executive oversight. * Design meaningful Key Performance Indicators (KPIs), portfolio metrics, and visualizations that clearly communicate organizational performance and portfolio health. * Develop automated reporting processes that improve reporting accuracy, consistency, and timeliness. * Produce recurring and ad hoc executive reports for organizational leadership, governance bodies, and business stakeholders. Data Engineering and Integration * Design, develop, and maintain data pipelines that integrate information from the organization's Project Portfolio Management (PPM) platform, business intelligence environment, financial systems, governance repositories, and other enterprise data sources. * Develop, optimize, and maintain complex SQL queries, data models, and data transformation processes. * Design scalable data models that support enterprise reporting and analytical capabilities. * Ensure data quality, consistency, integrity, and reliability across reporting environments. * Recommend improvements to the enterprise data architecture supporting investment management and portfolio reporting. Portfolio Analytics * Analyze project, portfolio, financial, schedule, resource, governance, and operational data to identify trends, risks, opportunities, and emerging issues. * Assess project health, risk management effectiveness, deliverable quality, and compliance with applicable standards and governance requirements. * Perform root-cause analysis to identify systemic portfolio issues and recommend corrective actions. * Identify risks and opportunities that require escalation to portfolio management and executive leadership. * Develop predictive and trend-based reporting to support proactive portfolio management and investment decision-making. Business Analysis and Stakeholder Engagement * Facilitate meetings with business stakeholders to identify reporting requirements, performance measures, and analytical needs. * Gather, analyze, and document business and technical requirements for enterprise reporting solutions. * Translate business requirements into technical reporting, dashboard, and data solutions. * Recommend reporting strategies, visualization approaches, and analytical solutions that improve executive decision-making. * Document business requirements, technical specifications, data definitions, metadata, and reporting standards. Continuous Improvement * Identify opportunities to automate manual reporting activities and improve reporting efficiency. * Recommend enhancements to portfolio reporting processes, governance metrics, and business intelligence capabilities. * Support the development and maintenance of enterprise reporting standards for project and investment management. * Participate in continuous improvement initiatives supporting organizational methodologies, investment management practices, and enterprise reporting capabilities. * Provide knowledge transfer, documentation, and technical guidance to internal staff to support long-term sustainability. ## 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) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)