Associate Data Engineer
Department: Data and Analytics
Reports to: Data & Analytics Lead
Pogue Construction is seeking an Associate Data Engineer to help build and maintain the data pipelines, API integrations, and dashboards our teams use to make business decisions. As the third member of our data team, this role will work closely with the Data & Analytics Lead and our existing technical team member to keep data accurate, available, and useful across the company.
The Associate Data Engineer will support the data lifecycle from source onboarding and ingestion through transformation, reporting, monitoring, and retirement. The primary focus is hands-on data engineering and API management, with ongoing Power BI dashboard support. This is an opportunity to develop engineering skills while learning how project, financial, and operational information moves through a construction business.
The role will take day-to-day responsibility for assigned integrations and support tasks under established standards and technical guidance. The Data & Analytics Lead will set priorities and retain responsibility for architecture, governance, and production approval, working with IT, Information Security, and department data owners.
- 0-2 years of relevant experience in data engineering, analytics, software development, or technical application support. Internships, co-ops, and substantial academic or personal projects will be considered.
- Practical experience using SQL and a scripting language to retrieve, transform, validate, or troubleshoot data.
- Degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent practical training and experience.
- Build and maintain assigned data pipelines using approved patterns to bring information from APIs, databases, and files into Pogue's data platform.
- Support new source onboarding by profiling data, documenting field mappings and refresh requirements, and validating initial loads with the team and source owners.
- Develop and maintain SQL transformations, notebooks, and dataflows that prepare source data for Silver and Gold tables and downstream reporting.
- Support incremental loads, scheduling, dependencies, retries, and controlled reruns or backfills. Investigate missing records, duplicate data, schema changes, and pipeline failures.
- Develop, test, and maintain API connections for business systems such as CMiC, Procore, and scheduling platforms as assigned.
- Handle authentication, pagination, rate limits, payload mapping, and error responses using established integration and security practices.
- Maintain an API inventory documenting endpoints, system owners, permissions, dependencies, refresh schedules, and support contacts. Track credential expiration and coordinate approved rotation with IT and system owners.
- Monitor integration health and vendor API changes. Test version changes, troubleshoot failed requests, and support approved internal APIs that provide curated data to other applications.
- Maintain and enhance Power BI reports using approved semantic models, KPI definitions, report standards, and Pogue branding.
- Investigate refresh failures, incorrect results, filter behavior, and access issues. Trace problems through the report, model, pipeline, and source system, and escalate issues outside the assigned scope.
- Gather and document user requests, deliver small report improvements, support user acceptance testing, and create practical guidance that helps employees use reports correctly.
- Implement and maintain checks for completeness, freshness, duplicate keys, and reconciliation to source totals. Work with department data owners to investigate discrepancies.
- Keep mappings, lineage, dependencies, runbooks, and change records current so another team member can support assigned assets.
- Use version control, peer review, testing, and established release procedures. Document deployment and recovery steps, communicate service interruptions, and help resolve recurring problems.
- Follow approved access, classification, and retention practices. Support archiving and retirement of unused datasets, integrations, and reports after checking dependencies and obtaining the required approval.
- Working knowledge of SQL, including joins, aggregations, and troubleshooting query results.
- Foundational Python or comparable scripting skills for data processing and automation.
- Understanding of relational databases, data transformation, and the purpose of ETL or ELT pipelines.
- Familiarity with REST APIs, HTTP requests, JSON, and authentication concepts.
- Ability to troubleshoot methodically, validate results, and document work clearly.
- Clear communication with technical colleagues and business users, sound handling of confidential information, and willingness to learn through feedback and review.
- Exposure to Microsoft Fabric, including pipelines, notebooks, lakehouses, warehouses, or dataflows.
- Experience with Power BI, Power Query, DAX, semantic models, and refresh troubleshooting.
- Familiarity with Git, Azure DevOps, automated testing, monitoring, or deployment workflows.
- Exposure to OAuth, service principals, secure credential storage, or API testing tools such as Postman.
- Familiarity with CMiC, Procore, Primavera P6, Microsoft Project, or construction accounting and project operations.
