Analytics Engineer II

Overview

The Opportunity

At ConstructConnect, our Analytics team plays a vital role in driving impactful business decisions and strategy through trusted and scalable data solutions. Recognizing the significance of our function, we have embraced a modern data stack that enhances our scalability, flexibility, and efficiency. Our current tech stack comprises Fivetran for extraction, dbt for transformation, Google BigQuery for storage, Power BI for reporting and analytics, and Hightouch for Reverse ETL. We are committed to staying at the forefront of technology and continuously exploring innovative solutions to maximize the value of our data.

We are seeking a skilled Analytics Engineer II to transform raw data into actionable insights by leveraging modern data warehousing techniques, advanced data modeling, and a deep understanding of business needs. In this role, you’ll combine the strengths of data engineering and analytics to create scalable data solutions and empower stakeholders with actionable insights. Strong communication and leadership skills are critical, as you’ll collaborate with business leaders and subject matter experts to deliver impactful solutions that align with organizational objectives.

Responsibilities

What You’ll Be Doing

• Design, build, and optimize scalable data models and transformation pipelines to support analytics and business intelligence.
• Partner with data owners and business stakeholders to define requirements and shape data strategies.
• Implement best practices for data governance, performance tuning, and observability to ensure data reliability.
• Develop and maintain clean, efficient SQL and Python code for data transformation and automation.
• Enhance BI tools (Power BI, Tableau) with well-structured datasets and intuitive dashboards.
• Lead code reviews and mentor junior team members, fostering best practices in analytics engineering.
• Manage data pipeline integrations (e.g., Fivetran, Stitch) and cloud data warehouses (GCP preferred).
• Apply software engineering principles (version control, CI/CD, testing) to maintain a scalable analytics ecosystem.
• Enable self-service analytics, training stakeholders on effective data usage.
• Learn and apply AI technologies: Gain familiarity with AI tools and frameworks to assist in software development tasks such as automated testing, code optimization, and data analysis, contributing to improved project outcomes.
• This job description in no way implies that the duties listed here are the only ones that team members can be required to perform

Qualifications

What You Bring to the Team  

• Bachelor’s degree required; advanced degree preferred.
• 3-5 years of experience in directly related positions.
• Expertise in SQL scripting and optimization for large-scale data.
• Proficient with BI tools (Power BI, Tableau, Looker).
• Strong background in data warehousing concepts, ELT workflows, and cloud-based analytics platforms (GCP preferred).
• Experience mentoring junior analytics engineers or leading technical initiatives.
• Solid grasp of software engineering practices for analytics, including version control (Git), CI/CD, and code modularity.
• Python and dbt experience preferred.
• Must have a high level of analytical and interpersonal skills.
• Handles sensitive and confidential data/information.

Physical Demands and Work Environment

• The physical activities of this position include frequent sitting, telephone communication, working on a computer for extended periods of time. Visual acuity is required to perform activities close to the eyes.  
• This position is a hybrid position and team members are expected to have a dedicated and established remote workspace.
• Ability to work hybrid in the Greater Cincinnati/Northern Kentucky Area.

E-Verify Statement ConstructConnect utilizes the E-Verify program with every potential new hire. This makes it possible for us to make certain that every employee who works for ConstructConnect is eligible to work in the United States. To learn more about E-Verify you can call 1-800-255-7688 or visit their website. E-Verify® is a registered trademark of the United States Department of Homeland Security. 

Privacy Notice