Associate Data Engineer

Tundra Technical Solutions; Jacksonville (FL); On-site; USD 70,000 - 100,000; Full time

Job summary

Tundra Technical Solutions is seeking an Associate Data Engineer in Jacksonville to work across IT and business units, creating reports and data files from multiple Access databases and tables to drive decision making.

The role focuses on building and running mission-critical departmental reporting, developing stored procedures, views, and data pipelines with Toa d, SQL Server, SSIS, and complementary tools, and translating analyses into actionable insights for stakeholders.

Qualifications

• Design and develop ETL using Toad and SQL Server stored procedures or other tools to create reports from Access databases.
• Translate business needs to data elements in Access Databases and data marts for source, extract, and match for reporting.
• Create and maintain dashboards and data sources in Tableau and other tools; extract and aggregate data as needed for reporting.
• Develop reports documenting analyses and ensure stakeholders understand business implications and trends.

Responsibilities

• Design and develop ETL pipelines and data transformations.
• Oversee daily running of departmental reporting for metric results.
• Create dashboards and data sources to support reporting efforts.
• Document analyses and present findings to stakeholders; recommend improvements.

Skills

ETL development

SQL reporting

Data analysis

Tableau dashboards

Root cause analysis

Education

Bachelor’s degree or equivalent work experience

Tools

Toad

SQL Server

SSIS

Posit

R

Job description

• The Associate Data Engineer works across IT and business functions to create and maintain custom reports and/or data files from multiple access databases and tables well helping drive business decision with business owners through development business comprehensive analyses.
• This role oversees the creation and daily running of mission critical departmental reporting for departmental metric results as well as design and develop Toad and SQL Server stored procedures, functions, and views. This role will provide presentations, documenting analyses, ensure understanding of the analysis with key stakeholder, and support on root causes of trends, issues, and performance gaps based on analyses as well as making and implementing recommendations to drive improvements.

Essential Functions:

• Design and develop ETL using Toad and SQL Server stored procedures or other tools , functions, and views. Create and maintain custom reports and/or data files from multiple access databases.
• Provide oversight for the creation and daily running of mission critical departmental reporting for departmental metric results. Translate business needs to data elements in Access Databases and other data marts to source, extract, and match and modify data to enable reporting efforts.
• Create and maintain custom dashboards and/or data sources in Tableau and other reporting tools; Extract and aggregate data as needed for reporting.
• Develop reports and presentations documenting analyses and ensure that key stakeholders understand the business implications for those analyses.
• Identify, investigate, and document possible root causes of trends, issues, and performance gaps based on analyses and campaign results to determine improvements and recommendations. Perform exploratory data analysis, data cleansing, and data visualization using data mining tools.

Required Work Experience:

Years of Experience:

• 3+ years related work experience

Experience Details:

• Or 1.5 years’ experience in an Associate Data Engineer role or experience in Data Analytics

Required Education:

• Related Bachelor’s degree or additional related equivalent work experience

Additional Info:

• Posit / R
• SSIS
• Transition existing SSIS ETL Pipelines from SSIS to Posit and R