Data Engineer

5 days ago

Overland, United States Clayco Full time

About Us

Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of building," providing fast track, efficient solutions for industrial, commercial, institutional, and residential related building projects.


The Role We Want You For

We are seeking a highly skilled and motivated Data Engineer to join our dynamic Data Analytics team in Overland, MO. As a Data Engineer at Clayco, you will play a vital role in designing, building, and maintaining data pipelines and complex data sets to support reporting, advanced analytics, and ad-hoc analysis. We are looking for a candidate with deep technical knowledge, a strong background in testing code, platform support, and data performance management. This position requires excellent communication skills to effectively collaborate with technical teams and translate business requirements into scalable data solutions.


The Specifics of the Role

  • Design, build, and maintain data pipelines from various source systems into Snowflake.
  • Analyze data elements, data flow, dependencies, and relationships from different systems and assist in designing conceptual, physical, and logical data models.
  • Develop complex data sets to fulfill diverse business needs in reporting, advanced analytics, and ad-hoc analysis.
  • Coordinate with third-party service providers for the construction and maintenance of data pipelines.
  • Execute and enable data migrations across systems, such as SQL Server to Snowflake or other cloud data platforms.
  • Develop and implement scripts for data hub maintenance, monitoring, and performance tuning.
  • Collaborate with data and business analysts to deploy and support a robust data quality platform.
  • Work with data and business analysts to deploy and support a comprehensive data cataloging strategy.
  • Assist various business and technical stakeholders with data-related technical needs and issues.
  • Collaborate closely with cross-functional teams to understand and transform business requirements into scalable and manageable data solutions.
  • Present solutions and options to leadership, project teams, and stakeholders, adapting the communication style to both technical and non-technical audiences.
  • Ensure adherence to documented design and development patterns and standards within the team.
  • Proactively monitor and resolve ongoing production issues.
  • Promote the approach of self-service data solutions and enable other teams with analytics solutions delivery through a 'Data as a Service' model.


Requirements

  • Hands-on experience in designing, developing, and implementing data solutions.
  • Advanced SQL knowledge with strong query writing and stored procedures skills.
  • Strong experience with relational databases such as SQL Server and Oracle.
  • Proficiency in object-oriented/object function scripting languages such as Python, Java, Scala, etc.
  • Basic knowledge and understanding of Azure cloud services.
  • Basic knowledge and understanding of stream-processing systems such as Storm, Spark-Streaming, etc.
  • Experience with data analysis, ETL, and workflow automation.


Some Things You Should Know

  • No other builder can offer the collaborative design-build approach that Clayco does.
  • We work on creative, complex, award-winning, high-profile jobs.
  • The pace is fast


Why Clayco?

  • Best Places to Work – St. Louis Business Journal, Los Angeles Business Journal, Phoenix Business Journal.
  • ENR – Top Midwest Contractors (#1), Top Design Build Contractors (#4), Top 400 Contractors (#23), ENR – Top Green Builders (#5).


Compensation and Benefits

  • Salary Range: Competitive Annual Salary based on qualifications, skills, training, experience, and location.
  • Discretionary Annual Bonus: Subject to company performance and individual contribution.
  • Comprehensive Benefits Package Including: Medical, dental and vision plans, 401k, generous PTO and paid company holidays, employee assistance program, flexible spending accounts, life insurance, disability coverage, learning & development programs and more

  • Data Engineer

    6 days ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Data Engineer II

    2 weeks ago

    Overland Park, United States Corporate Propio Language Services Full time

    Propio Language Services is transforming communication by developing tools and technologies that make it easier and more efficient for clients to engage with the Limited English Proficiency Population to improve access to healthcare and essential services in social services, education, legal and many others. The Data Engineer II will play a key role in...

  • Data Engineer II

    2 months ago

    Overland Park, United States Corporate Propio Language Services Full time

    Job DescriptionJob DescriptionPropio Language Services is transforming communication by developing tools and technologies that make it easier and more efficient for clients to engage with the Limited English Proficiency Population to improve access to healthcare and essential services in social services, education, legal and many others.The Data Engineer...

  • Data Scientist

    2 months ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Data Scientist

    2 months ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Electrical Engineering Internship

    3 weeks ago

    Overland Park, United States Olsson Full time

    Job DescriptionJob DescriptionCompany DescriptionWe are Olsson, a team-based, purpose-driven engineering and design firm. Our solutions improve communities and our people make it possible.Our most meaningful asset is our people, and we are dedicated to providing an environment where they can continue to learn, grow, and thrive. Our entrepreneurial spirit is...

  • Enterprise Data Warehouse Developer

    2 weeks ago

    Overland Park, United States Rx Savings Solutions Full time

    **Enterprise Data Warehouse Developer** Overland Park, Kansas / Engineering Data Engineering / Full-time, Hybrid Here at Rx Savings Solutions, we are driven to make a difference in the pharmaceutical industry by exposing cost-savings analytics to our members. We take pride knowing that the work we do can greatly impact the lives of our customers. We...

  • Data Scientist

    4 weeks ago

    Overland Park, United States Disability Solutions Full time

    At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and...

  • Marketing Data Coordinator

    3 months ago

    Overland, United States Clayco Full time

    About Us:Clayco is a full-service, turnkey real estate development, master planning, architecture, engineering and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Data Analyst

    2 weeks ago

    Overland Park, United States Roc Search Full time

    Roc Search is currently working with a leading telecommunications organization that is looking for a Data Analyst to join their team.As a Data Analyst on the Fraud Protection Team, you will play a pivotal role in extracting, cleaning, and engineering data systems that automate fraud detection and prevention processes. Your primary responsibility will be to...

  • Sr Data Scientist

    4 weeks ago

    Overland Park, United States Disability Solutions Full time

    At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth-building opportunities through our annual stock grant, employee stock purchase plan, 401(k), and...

  • Senior Architectural Project Manager

    3 months ago

    Overland, United States Lamar Johnson Collaborative Full time

    About UsLamar Johnson Collaborative (LJC) is a team of high-energy professionals. We share a passion for design, a collaborative approach, and a casual culture. We solve challenges by leveraging the collective expertise and ingenuity of the best and brightest minds across development, design, and construction. Lamar Johnson Collaborative attracts a dynamic...

  • Data Migration and Analytics Professional

    6 days ago

    Overland Park, Kansas, United States Hill's Pet Nutrition Full time

    Job Title: Data Migration and Analytics InternJob Summary:Hill's Pet Nutrition is seeking a highly motivated and detail-oriented Data Migration and Analytics Intern to join our team. As a Data Migration and Analytics Intern, you will play a crucial role in our S/4HANA implementation project, working closely with our supply chain, data engineering, and...

  • Senior Data Analyst

    4 days ago

    Overland Park, Kansas, United States A Place For Mom Full time

    About the RoleWe are seeking a highly skilled Senior Data Scientist to join our team at A Place for Mom. As a key member of our data science team, you will be responsible for leveraging advanced analytics and machine learning techniques to drive business growth and inform strategic decisions.Key ResponsibilitiesData Science/Machine Learning Model Management...

  • Data Migration and Analytics Intern

    2 months ago

    Overland Park, United States Hill's Pet Nutrition Full time

    No Relocation Assistance Offered # 161611 - Overland Park, Kansas, United States Job Title: Data Migration and Analytics Intern Job Description: Position Overview: As a Data Migration and Analytics Intern, you will play a crucial role in our S/4HANA implementation project. You will work closely with our supply chain, data engineering, and...

  • Fire Protection Engineer

    2 weeks ago

    Overland Park, United States System One Full time

    Position Title: Fire Protection Engineer (Hybrid) – Overland Park, KS or Dallas, TX Position Overview: We are seeking an experienced Fire Protection Engineer to join our team in a hybrid role based in either Overland Park, KS or Dallas, TX. The engineer will be responsible for assessing facilities and equipment to establish appropriate fire protection...

  • Senior Preconstruction Engineer

    3 months ago

    Overland, United States Clayco Full time

    About UsClayco is a full-service, turnkey real estate development, master planning, architecture, engineering and construction firm that safely delivers clients across North America the highest quality solutions on time, on budget, and above and beyond expectations. With $5.8 billion in revenue for 2023, Clayco specializes in the "art and science of...

  • Business Intelligence Analyst

    4 days ago

    Overland Park, Kansas, United States Clayco Full time

    About UsClayco is a leading full-service, turnkey real estate development, master planning, architecture, engineering, and construction firm that delivers high-quality solutions to clients across North America. With a strong focus on innovation and customer satisfaction, Clayco specializes in providing efficient and effective solutions for industrial,...

  • Global Business Development Manager- Data Centers

    3 weeks ago

    Overland Park, United States SPX Cooling Tech, LLC Full time

    Building the people that build the world.With platforms in HVAC and Detection and Measurement, SPX Technologies builds innovative solutions that enable a safer, more efficient, sustainable world. Through our RiSE talent development framework, we Reach, Identify, Strengthen, and Engage our employees to support them in their continued development. We’re a...

  • Global Business Development Manager- Data Centers

    3 weeks ago

    Overland Park, United States SPX Cooling Tech, LLC Full time

    Building the people that build the world.With platforms in HVAC and Detection and Measurement, SPX Technologies builds innovative solutions that enable a safer, more efficient, sustainable world. Through our RiSE talent development framework, we Reach, Identify, Strengthen, and Engage our employees to support them in their continued development. We’re a...