Data Architect

OverviewJoin to apply for the Data Architect role at Kokosing. Kokosing is a large general contractor with services across heavy civil/industrial construction. The company seeks a Senior Data Engineer / Data Architect with hands-on experience designing and implementing modern data solutions across cloud and on-prem environments, and with leadership responsibilities to drive governance frameworks for enterprise data ecosystems.Location: Westerville, OH (and surrounding areas). This role requires collaboration with technical and business stakeholders to align data architecture with business objectives.Key ResponsibilitiesData Engineering & ArchitectureDesign, build, and optimize ETL pipelines using tools such as SSIS, Azure Data Factory, Alteryx, and Databricks.Design and implement modern data models, data lakes, data warehouses, data mesh, and cloud-native pipelines across SQL Server, Snowflake, AWS, and Azure ecosystems.Develop and maintain CI/CD pipelines using Azure DevOps, GitHub Actions, Docker, and Terraform.Lead the design and implementation of Change Data Capture (CDC) and data integration solutions.Implement data quality, lineage, and cataloging solutions.Data Governance & QualityEstablish and manage data catalogs and governance frameworks using tools like Azure Purview and Databricks Unity Catalog.Ensure data quality, lineage, and security across distributed systems.Document data architectures, pipelines, and standards to support maintainability and -depth knowledge of DAMA-BMBOK and DAMA International standards.Analytics & Business EnablementBuild dashboards and reporting solutions in Power BI and Business Objects to deliver insights across HR, Finance, and Operations.Identify high-value use cases for AI and predictive analytics in collaboration with stakeholders.Partner with stakeholders to translate business requirements into scalable technical troduce and apply AI/ML tools (Databricks Genie Spaces, Gemini, ChatGPT, CoPilot) to accelerate innovation and automation.Leadership & CollaborationServe as the technical leader and subject matter expert for data and AI/ML.Mentor junior engineers and analysts, promoting best practices in coding, design, and data strategy.Serve as a trusted advisor to cross-functional teams, providing expertise in database optimization, performance tuning, and workflow automation.Lead development collaboration efforts, including vendor evaluation and recruitment of data engineers, analysts, and data scientists as the team expands.QualificationsRequired10+ years of progressive experience in data engineering, architecture, and analytics roles.Proven expertise with SQL, Python, and C# for building enterprise-grade data solutions.Hands-on experience with cloud platforms: Azure (Azure SQL, Data Factory, Databricks, Purview) and AWS (Glue, S3).Strong background in data modeling, ETL design, governance, and performance tuning.Experience with DevOps practices (Azure DevOps, GitHub Actions, Docker, Terraform).Proficiency with reporting/BI tools (Power BI, Tableau, Business Objects, SSRS).Familiarity with AI/automation tools (Databricks Genie Spaces, ChatGPT, Gemini).Excellent communication skills and ability to collaborate with technical and non-technical stakeholders.Bachelor’s degree in Computer Science, Engineering, or related field (Mechanical Engineering background a plus).PreferredExperience and knowledge of the construction industry (construction, field operations, IoT, financials).Demonstrable experience delivering IT solutions that drove innovation.Certifications (Preferred)Microsoft Azure FundamentalsMicrosoft Azure Data FundamentalsMicrosoft Azure Security FundamentalsTeradata Vantage CertifiedKokosing is an equal employment opportunity/affirmative action federal and state contractor. The company does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected class.Job DetailsSeniority level: Mid-Senior levelEmployment type: Full-timeJob function: Engineering and Information TechnologyIndustries: ConstructionReferrals increase your chances of interviewing at Kokosing. Get notified about new Data Architect jobs in Westerville, OH. #J-18808-Ljbffr

Created: 2025-10-08