Onsite Junior BI Developer — Alpharetta Data Warehouse & BI

Pyramid Consulting, Inc; Alpharetta (GA); On-site; USD 55,000 - 58,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid sick leave

Job summary

Pyramid Consulting, Inc. seeks a Junior BI Developer for a 12+ months contract in Alpharetta, GA (onsite). The role focuses on building and maintaining data solutions, dashboards, and analytics support.

Ideal candidates have strong Power BI, data warehousing, and SQL skills, plus familiarity with AI concepts. A bachelor’s degree and 3–7+ years in data engineering or related fields are preferred. This contract may offer long-term potential.

Qualifications

• Bachelor’s degree in CS, Data Engineering, Information Systems, or related field (or equivalent).
• 3–7+ years of experience in data engineering, data warehouse development, or related role.
• Strong SQL skills with query optimization, joins and window functions.
• Experience with BI tools (Power BI) and KPI dashboards.

Responsibilities

• Note -looking citizen/GC/GC-EAD/L2ead/h4ead/opt-ead/TN. NO H1B.
• Data Warehouse Architecture & Engineering: design and maintain scalable data warehouse solutions.
• Develop, optimize, and maintain complex SQL queries, stored procedures, and ETL/ELT pipelines.
• Implement data quality checks, validation rules, and performance tuning for large datasets.
• Collaborate with BI and analytics teams to ensure warehouse meets reporting and SLA requirements.
• AI / Machine Learning Engineering: design, build, and deploy AI/ML models using warehouse data.
• Partner with business stakeholders to translate requirements into AI use cases and measurable outcomes.
• Create reusable features, frameworks, and components to accelerate AI delivery.
• Work with data engineers, data analysts, and business SMEs to understand data sources and logic.
• Contribute to data architecture standards, documentation, and best practices.

Skills

Power BI

Data warehousing

SQL

Python

Education

Bachelor’s degree in CS, Data Engineering, IS, or related field

Tools

Data Factory

Informatica

dbt

SSIS

Job description

Pyramid Consulting, Inc. seeks a Junior BI Developer for a 12+ months contract in Alpharetta, GA (onsite). The role focuses on building and maintaining data solutions, dashboards, and analytics support.

Ideal candidates have strong Power BI, data warehousing, and SQL skills, plus familiarity with AI concepts. A bachelor’s degree and 3–7+ years in data engineering or related fields are preferred. This contract may offer long-term potential.