Data Analyst
Posted Updated
Summary
Fully onsite Data Analyst (placed by staffing firm Vernovis for a Dayton-area client, likely construction) reporting to the CIO: builds SQL queries, Snowflake medallion-architecture models and Power BI dashboards, owns Azure Data Factory ETL pipelines, and maintains data governance and quality.
Data Analyst
Location: Miamisburg, OH
Work Arrangement: Fully Onsite
Job Type: Full-Time, Direct Hire
Reports to: Chief Information Officer
Vernovis is partnering with an established organization in the Dayton area seeking an experienced Data Analyst. The Data Analyst transforms raw data into actionable insights that support operational, financial and strategic decision-making. This hands-on role develops the queries, data models, dashboards and reports that project managers, operations leaders and executives rely on to make informed decisions. The position also owns and maintains the Snowflake data warehouse and associated data pipelines, integrating information from source systems such as Vista and Autodesk ACC (Forma) while onboarding new data sources to support evolving business and analytics needs.
Reporting directly to the CIO, this position offers significant autonomy and the opportunity to influence data architecture, governance and emerging technologies, including AI-driven analytics. The ideal candidate is a proactive, technically skilled professional who enjoys solving complex problems, collaborating with business leaders and taking ownership of solutions from development through implementation.
What You’ll Do:
Data Warehouse & Pipelines
Required Skills & Qualifications
Technical Skills
Preferred Qualifications
Working Conditions and Physical Demands:
Work is primarily performed in an office environment with occasional visits to active construction sites. The employee must be able to safely navigate uneven terrain, stairs, and other jobsite conditions. The position requires prolonged periods of sitting, computer use, and effective communication. Occasional travel may be required.
----------------
Who We Are: Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. At Vernovis, we help these professionals achieve their career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest.
Vernovis does not accept inquiries from Corp to Corp recruiting companies. Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws.
Vernovis provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://vernovis.com/privacy-policy-2/.
Location: Miamisburg, OH
Work Arrangement: Fully Onsite
Job Type: Full-Time, Direct Hire
Reports to: Chief Information Officer
Vernovis is partnering with an established organization in the Dayton area seeking an experienced Data Analyst. The Data Analyst transforms raw data into actionable insights that support operational, financial and strategic decision-making. This hands-on role develops the queries, data models, dashboards and reports that project managers, operations leaders and executives rely on to make informed decisions. The position also owns and maintains the Snowflake data warehouse and associated data pipelines, integrating information from source systems such as Vista and Autodesk ACC (Forma) while onboarding new data sources to support evolving business and analytics needs.
Reporting directly to the CIO, this position offers significant autonomy and the opportunity to influence data architecture, governance and emerging technologies, including AI-driven analytics. The ideal candidate is a proactive, technically skilled professional who enjoys solving complex problems, collaborating with business leaders and taking ownership of solutions from development through implementation.
What You’ll Do:
Data Warehouse & Pipelines
- Develop, maintain and optimize SQL queries, stored procedures and data transformations to extract and integrate data from ERP, project management, financial and operational systems.
- Own and monitor ETL/ELT pipelines using Azure Data Factory and other integration tools, including scheduling data loads, troubleshooting failures, resolving discrepancies and optimizing performance.
- Maintain and enhance the existing Snowflake data warehouse, ensuring reliable data integration, performance and accessibility for downstream reporting and analytics.
- Work within Snowflake's medallion architecture, including raw data ingestion (bronze), data cleansing, transformation and validation (silver), and business-ready dimensional models and star schemas (gold) to support Power BI reporting.
- Onboard and integrate new data sources, including databases, APIs and file-based feeds, as business and reporting needs evolve.
- Evaluate existing data architecture and emerging technologies, including Microsoft Fabric and Azure Synapse, and recommend improvements to integration strategies, scalability and platform capabilities.
- Design, develop and maintain Power BI dashboards, reports and analytical models that support operational, financial and strategic decision-making.
- Translate business and project-related questions into SQL queries, datasets and analytical models, performing ad-hoc analysis to support leadership and operational teams.
- Analyze data across ERP, project management, financial, timekeeping, estimating and operational systems to identify trends, risks and opportunities.
- Develop reporting and analytics related to:
- Project costs, budgets versus actuals and forecast-at-completion
- Labor productivity, crew performance and utilization
- Change orders, RFIs and schedule impacts
- Margin analysis at the project, phase and job cost code levels
- Identify opportunities to expand reporting and analytics capabilities through automation, advanced data modeling and AI-driven solutions.
- Validate data accuracy, completeness and consistency across job cost, labor, equipment and schedule data, including quality checks and reconciliation throughout the data warehouse.
- Troubleshoot data discrepancies and collaborate with IT and business teams to resolve issues involving cost codes, phase structures, labor classifications and project hierarchies.
- Maintain and expand data dictionaries, standardized definitions, calculations, reporting logic and key performance indicators.
- Establish and improve data governance, documentation and validation practices to ensure data integrity, consistency and security.
- Proactively identify opportunities to improve data quality, integration processes and overall reporting capabilities.
- Work directly with the CIO, finance, operations, project management, estimating and executive leadership to understand business priorities, reporting requirements and performance metrics.
- Translate complex business needs into scalable data solutions, dashboards and actionable insights.
- Communicate technical concepts and analytical findings clearly to technical and non-technical stakeholders.
- Independently evaluate challenges, recommend solutions and take ownership of initiatives from concept through execution.
Required Skills & Qualifications
Technical Skills
- SQL: Advanced SQL skills, including complex queries, joins, CTEs, aggregations, stored procedures and performance optimization.
- Data Pipelines & Integration: Hands-on experience developing, scheduling, monitoring and troubleshooting ETL/ELT pipelines using Azure Data Factory and integrating data from databases, APIs and file-based sources.
- Data Warehousing & Modeling: Experience with Snowflake, relational databases and data modeling concepts, including dimensional modeling, star schemas and layered data architectures such as medallion (bronze, silver and gold).
- Business Intelligence: Proficiency in developing dashboards and reports using Power BI, along with advanced Excel skills, including Power Query, PivotTables and formulas.
- Microsoft Data Platforms: Familiarity with Microsoft Fabric and cloud data warehouse technologies such as Azure Synapse and Azure Data Lake, including their capabilities for data integration, warehousing and analytics.
- Data Management & Governance: Experience with data validation, quality management, troubleshooting, technical documentation and data governance principles.
- Strong analytical and problem-solving abilities, with demonstrated experience troubleshooting complex data and integration issues.
- Excellent verbal and written communication skills, including the ability to collaborate with IT, project managers, operations, finance and executive leadership.
- Self-directed and proactive, with the ability to independently identify challenges, recommend solutions and manage priorities with minimal oversight.
- Strong attention to detail and a commitment to data accuracy, documentation and continuous improvement.
- Ability to translate complex technical information into meaningful business insights and actionable recommendations.
- Bachelor's degree in Information Systems, Data Analytics, Computer Science, Business Administration, Construction Management or a related field.
- 5+ years of progressive experience in data analytics, business intelligence, data engineering or related roles.
Preferred Qualifications
- Experience with construction or project-based ERP systems, including job costing, labor, equipment and project accounting, and platforms such as Vista by Viewpoint and Autodesk ACC (Forma) Cost.
- Understanding of project controls, earned value concepts, labor metrics, cost forecasting and operational KPIs, with experience supporting field operations, project management or estimating teams through data analytics.
- Industry experience in construction, engineering, manufacturing, supply chain, field services or another project-based environment.
- Experience developing reports using SQL Server Reporting Services (SSRS) or Tableau.
- Python or R experience for data analysis, automation and advanced analytics.
- Experience evaluating data architecture, integration strategies and cloud analytics platforms to recommend technology improvements.
- Interest in artificial intelligence, machine learning and emerging data analytics technologies.
Working Conditions and Physical Demands:
Work is primarily performed in an office environment with occasional visits to active construction sites. The employee must be able to safely navigate uneven terrain, stairs, and other jobsite conditions. The position requires prolonged periods of sitting, computer use, and effective communication. Occasional travel may be required.
----------------
Who We Are: Vernovis is a Total Talent Solutions company that specializes in Technology, Cybersecurity, Finance & Accounting functions. At Vernovis, we help these professionals achieve their career goals, matching them with innovative projects and dynamic direct hire opportunities in Ohio and across the Midwest.
Vernovis does not accept inquiries from Corp to Corp recruiting companies. Applicants must be currently authorized to work in the United States on a full-time basis and not violate any immigration or discrimination laws.
Vernovis provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://vernovis.com/privacy-policy-2/.
Skills
- Accessibility
- AI
- Analytics
- API
- Automation
- Azure
- Azure Data Factory
- Azure Synapse
- Business Intelligence
- Cloud
- Cybersecurity
- Data Analytics
- Data Engineering
- Data Governance
- Data Ingestion
- Data Lake
- Data Modeling
- Data Pipelines
- Data Quality
- Data Warehousing
- Dimensional Modeling
- ELT
- ERP
- ETL
- Excel
- Machine Learning
- Medallion Architecture
- Microsoft Fabric
- Power Query
- Power BI
- Python
- RDBMS
- Snowflake
- SQL
- SQL Server
- SSRS
- Tableau
Sign in to read and join the discussion.