BI Developer

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). Please review the job description below and contact me ASAP if you are interested., * 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 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., Amazon Web Services (AWS), Analysis Skills, Artificial Intelligence (AI), Artificial Intelligence (AI) Programming Languages, Best Practices, Business Intelligence, Business Intelligence Software, Business Skills, Cloud Computing, Communication Skills, Computer Science, Consulting, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Documentation, EAD, Employee Benefits, Finance, Forecasting, GCP (Good Clinical Practices), Identify Issues, Informatica, Information Technology & Information Systems, Information/Data Security (InfoSec), Machine Learning, Microsoft Windows Azure, Multitasking, Natural Language Processing (NLP), Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Project/Program Management, Python Programming/Scripting Language, Qlik, Query Optimization, R Programming Language, Reporting Dashboards, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Service Level Agreement (SLA), Short Messaging Service (SMS), Star Schema, Stored Procedures, Structured Data, Tableau, Team Player, Use Cases, Validation Testing, Warehousing

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).

Our client is a leading Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

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.