Data Analytics Engineer

Brooksource; Columbus (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

Brooksource is seeking a Data Analytics Engineer to support a large-scale data modernization initiative. You will build Snowflake data models with dbt, write optimized SQL, and assist migrating reports to the cloud data warehouse, enabling enterprise analytics.

You'll collaborate with Data and BI Engineers, participate in Agile ceremonies, and apply dimensional modeling best practices to deliver scalable data solutions for stakeholders across the organization.

Qualifications

• Bachelor's degree or equivalent practical experience.
• Strong SQL fundamentals including joins and aggregations.
• Ability to communicate technical concepts to diverse stakeholders.
• Exposure to Snowflake or cloud data warehouse technologies.
• Familiarity with dbt and modern data modeling concepts.
• Exposure to Python, Airflow or related data engineering tools preferred.

Responsibilities

• Build Snowflake data models using dbt and translate business requirements into scalable tables.
• Write and optimize SQL queries for data transformation and analytics needs.
• Support migration of reports from legacy platforms to a modern cloud data warehouse.
• Apply dimensional modeling and star-schema best practices in warehouse design.
• Collaborate with Data Engineering to resolve data pipeline dependencies.
• Support downstream reporting and dashboard needs with BI Engineers.
• Participate in Agile ceremonies, sprint planning and team collaboration.

Skills

SQL fundamentals

Communication to stakeholders

Agile methodologies

Data analytics mindset

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

dbt

Python

Airflow

Job description

Brooksource is seeking a Data Analytics Engineer to support a large-scale data modernization initiative for an organization. This role will focus on building and maintaining data models within a modern Snowflake-based data warehouse environment while helping migrate reporting assets from legacy platforms. You'll work alongside Data Engineers, BI Engineers, and project leadership to deliver high-quality data solutions that enable enterprise reporting and analytics. This is an excellent opportunity for someone early in their data career to gain hands-on experience with Snowflake, dbt, SQL, and modern data warehousing practices.

What You'll Do:

• Build and maintain Snowflake data models using dbt, translating business requirements into scalable fact and dimension tables.
• Write and optimize SQL queries for data transformation, validation, and analytics needs.
• Support migration efforts from legacy reporting platforms to a modern cloud data warehouse environment.
• Apply dimensional modeling and star-schema best practices when designing warehouse structures.
• Partner with Data Engineering teams to resolve data pipeline dependencies and ensure data availability.
• Collaborate with BI Engineers to support downstream reporting and dashboard requirements.
• Participate in Agile ceremonies, sprint planning, and team collaboration activities.

What You Bring:

• Bachelor's degree in Computer Science, Data Analytics, Information Systems, or a related field, or equivalent practical experience.
• Strong SQL fundamentals including joins, aggregations, and data transformation.
• Ability to communicate technical concepts effectively to both technical and non-technical stakeholders.
• Exposure to Snowflake or other cloud data warehouse technologies.
• Familiarity with dbt and modern data modeling concepts.
• Exposure to Python, Airflow, or related data engineering tools is preferred.