Junior BI Developer

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

Benefits offered by this job

Health insurance

401(k)

Paid sick leave

Job summary

Pyramid Consulting, Inc. requires a Junior BI Developer for an onsite, Alpharetta, GA contract of 12+ months. The role focuses on data warehouse architecture, Power BI dashboards, and SQL-based data pipelines to enable reporting, analytics, and AI initiatives.

The ideal candidate will have 3–7+ years in data engineering, strong SQL skills, and familiarity with cloud data warehouse technologies. Onsite work with benefits and long-term opportunities.

Qualifications

• 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 including window functions and stored procedures.

Responsibilities

• Data Warehouse Architecture & Engineering to support reporting and analytics.
• Design, build, and maintain scalable data warehouse solutions and pipelines.
• Develop, optimize, and maintain complex SQL queries and ETL/ELT processes.
• Implement data quality checks and performance tuning for large datasets.
• Collaborate with BI/analytics teams to meet reporting and SLA requirements.
• Support AI/ML workflows by designing features and pipelines from warehouse data.
• Work with data engineers, analysts, and SMEs to understand data sources and business logic.

Skills

Power BI

Data Warehousing

SQL

Education

Bachelor's degree in CS/IS or related field

Tools

ETL/ELT tools

Cloud DW platforms (Azure/AWS/GCP)

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.
• Collaboration & Governance
• 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 FinancialIndustry, 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.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here. #prof