Data Engineer Advisor

Compunnel, Inc.; Atlanta (GA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading tech company is looking for a Data Engineer Advisor to design robust reporting infrastructure and data pipelines. You will architect data storage, define data models, and ensure data quality while mentoring team members. Ideal candidates will have 8-10 years of experience in data warehousing and be proficient in SQL and reporting tools like Tableau and Power BI. This is an exciting opportunity to lead technical projects in a dynamic environment.

Qualifications

• 8–10 years of experience in designing and implementing data warehouses and scalable storage solutions.
• Strong proficiency in SQL and data querying languages.
• Extensive experience with reporting tools such as Tableau, Power BI, or Cognos.

Responsibilities

• Architect data storage, transformation, and delivery systems including data warehouses.
• Create logical and physical data models optimized for reporting and analysis.
• Implement ETL/ELT processes for accurate data delivery.

Skills

SQL

Data warehousing

Data integration

Reporting tools

Data governance

Analytical skills

Tools

Tableau

Power BI

Cognos

Job description

We are seeking a Data Engineer Advisor to lead the design and implementation of robust reporting infrastructure and data pipelines.

This role involves architecting data storage solutions, defining data models, ensuring data quality and security, and mentoring team members.

The ideal candidate will have extensive experience in data warehousing, reporting tools, and data integration processes.

Key Responsibilities

• Design Reporting Infrastructure: Architect data storage, transformation, and delivery systems including data warehouses, lakes, and reporting databases.
• Define Data Models: Create logical and physical data models optimized for reporting and analysis, including fact-dimensional modeling.
• Develop Data Pipelines: Implement ETL/ELT processes to ensure accurate and high-quality data delivery.
• Select and Implement Reporting Tools: Configure platforms such as Tableau, Power BI, or Cognos to integrate with data infrastructure.
• Ensure Data Quality and Security: Apply data quality checks and security protocols to safeguard sensitive information.
• Provide Technical Leadership: Mentor data engineers and analysts, optimize reporting system performance, and collaborate with stakeholders to align infrastructure with business needs.

Required Qualifications

• 8–10 years of experience in designing and implementing data warehouses, data marts, and scalable data storage solutions.
• Strong proficiency in SQL and other data querying languages.
• Extensive experience with reporting tools such as Tableau, Power BI, or Cognos.
• Deep expertise in ETL processes and data integration from multiple sources.
• Solid understanding of data governance and security principles.
• Excellent communication skills for engaging with technical and non-technical stakeholders.
• Strong analytical and problem-solving abilities.

Preferred Qualifications

• Experience in performance tuning and optimization of reporting systems.
• Background in mentoring and leading technical teams.