Junior BI Developer

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

Immediate need for a talented Junior BI Developer. This is a 12+months contract opportunity with long-term potential and is located in Alpharetta, GA(Onsite).

Job ID: 26-29664

Pay Range: $40/hr - $42/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key 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 (e.g., star/Client schemas, dimensional models) to support reporting, analytics, and AI workloads.
• 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 the warehouse meets reporting and SLA requirements.
• AI / Machine Learning Engineering
• Design, build, and deploy AI/ML models (e.g., classification, forecasting, NLP) using structured and semi-structured data from the warehouse.
• Partner with business stakeholders to translate requirements into AI use cases and measurable outcomes.
• Create reusable features, frameworks, and components that accelerate AI solution delivery.
• Work closely with data engineers, data analysts, and business SMEs to understand data sources and business logic.
• Contribute to data architecture standards, documentation, and best practices across the organization.
• Support troubleshooting and root-cause analysis for data and model-related issues.

Key Requirements and Technology Experience

• Key Skills; Strong Power BI experience
• Strong data warehousing experience
• SQL/data analysis skills
• This is not an AI Engineering or Data Architecture role.
• AI experience is a plus but is not a core requirement.
• Bachelor’s degree in computer science, Data Engineering, Information Systems, or related field (or equivalent experience).
• 3–7+ years of experience in data engineering, data warehouse development, or related role.
• Strong expertise in SQL (query optimization, complex joins, window functions, stored procedures).
• Hands-on experience designing and implementing data warehouse architectures (e.g., Kimball, Inmon, modern cloud data warehouses).
• Experience with at least one major cloud platform (e.g., Azure, AWS, GCP) and its data warehousing tools (e.g., Client, Redshift, BigQuery, Azure Synapse).
• Solid experience with at least one programming language for AI/ML (e.g., Python, R), and common ML libraries
• Proven ability to translate business problems into data and AI solutions.
• Experience with ETL/ELT tools (e.g., Data Factory, Informatica, dbt, SSIS).
• Familiarity with MLOps tools and concepts (e.g., MLflow, CI/CD pipelines for ML, model registries).
• Experience working with BI tools (e.g., Power BI, Tableau, Qlik) and supporting KPI dashboards.
• Knowledge of data governance, security, and compliance best practices.
• Strong communication skills and ability to work with both technical and non-technical stakeholders.
• Strong analytical and problem-solving skills.
• Ability to manage multiple projects and priorities in a fast-paced environment.
• Collaborative mindset and willingness to take ownership from concept to delivery.

Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.