Note: The job is a remote job and is open to candidates in USA. NELSON Worldwide is seeking a Senior Analytics Engineer responsible for designing, building, and maintaining critical data pipelines and infrastructure solutions. The role focuses on delivering production-ready data solutions and collaborating with stakeholders to support data-driven decision-making.
Responsibilities
- Deliver production-ready ETL/ELT pipelines supporting project, financial, and operational data
- Translate business requirements into clean, scalable data models with minimal rework
- Improve performance, reliability, and usability of existing data pipelines and reporting solutions
- Migrate core data infrastructure from legacy systems to modern platforms, supporting the business’s shift to a data product-first strategy
- Effectively collaborate with stakeholders in AEC, design, or project-based environments
- Design, build, and maintain production data pipelines
- Develop reliable ingestion processes across structured and unstructured data sources
- Support integrations across enterprise and design-related platforms
- Optimize pipelines for performance, scalability, security, and cost efficiency
- Ensure data is reliable, scalable, and accessible
- Partner with IT, Enterprise and Practices to enable smooth data operations
- Maintain cloud data stores that support analytics, reporting and other data products
- Own and optimize SQL queries, stored procedures, and scheduled jobs for data product workflows
- Build and maintain analytics-ready data models and semantic layers
- Align data models to business logic, metrics, and data product needs
- Evaluate and recommend improvements to tools, data structures, and analytics approaches
- Ensure data quality, consistency, and usability through validation, governance, and documentation
- Deliver reliable datasets for business users and project teams
- Implement data validation, audits, and error handling
- Ensure compliance with data privacy, security standards, and IT policies
- Create documentation, metadata, data dictionaries, and best practices
- Translate business requirements into data models and pipeline solutions
- Work within established architecture patterns to deliver scalable and maintainable solutions
- Contribute to recommendations on data structures, tools, and reporting approaches
- Work with business stakeholders to understand business needs and define requirements
- Partner with stakeholders, analysts, and technical teams to deliver and support usable data products across functions
- Improve data-driven decision making and reduce manual delivery processes
- Support documentation, knowledge sharing, and solution standardization
Skills
- Strong proficiency in SQL and data modeling with a track record of building scalable solutions
- Hands-on experience developing and maintaining ETL/ELT production pipelines
- Experience working with the Azure Data Platform (Data Factory, Data Lake, Databricks preferred) in production environments
- Proven ability integrating data across multiple systems and APIs
- Solid understanding of data warehousing concepts and analytics data structures
- Proven track record translating business needs into technical requirements and delivering actionable data products
- Experience working with project-based data (financials, schedules, resource planning, or operational delivery data)
- Experience working in environments where data is distributed across multiple systems
- Bachelor's Degree in Computer Science, Data (or related field), or equivalent in appropriate education and experience
- 5–8+ years of experience in data engineering, BI, or analytics delivery roles
- Proven experience delivering production data and analytics solutions
- Experience supporting data products in AEC (Architecture, Engineering, Construction), design, or real estate consulting environments OR similar project-based industries (construction, engineering, capital projects)
- Experience with Deltek Vantagepoint, HubSpot, UltiPro, or similar enterprise systems
- Experience with BIM, CAD, or design platforms (Revit, AutoCAD, BIM 360, ACC)
- Experience improving data consistency across disconnected systems
- Experience implementing data quality frameworks to identify where data quality degrades and fix root causes, not just downstream reporting issues
- Experience supporting business intelligence reporting for project performance analytics, forecasting, and/or resource planning
- Understanding of and some hands-on experience with the end-to-end business intelligence build/maintain lifecycle (data model → dataset → dashboard) using Power BI and/or Tableau
Benefits
- 401(K) plan with company match
- Full health benefits including medical, dental, and vision
- Wellness program with rewards for healthy activities
- Pet Insurance
- Opportunities for career advancement
- Paid time off and holiday pay
- Paid parental leave
- Flexible working schedules and work from home options based on client’s needs
- Professional Development including discretionary support and reimbursement for registrations, certifications, and membership to a professional organization
Company Overview
Company H1B Sponsorship