Job description

Job Summary: The Allegis Corporate Services (ACS) Business Intelligence (BI) Developer will play a key role in delivering analytical applications such as dashboards, reports, and ad-hoc tools to the organization. This strategic position involves developing innovative visualizations and enterprise-wide insights within the ACS Business Intelligence & Analytics department using a modern data stack. Responsibilities include enhancement and maintenance of the current BI platform and creating new capabilities with advanced data transformation and visualization tools. The ideal candidate will be proficient in cloud data warehouses like Snowflake and experienced in modular data model creation for reporting. The BI Developer should be able to work independently and understand their work's broader impact on the organization. Essential Functions: • Contribute to BI solutions through the full delivery lifecycle, including requirements discovery, source assessment, data modeling, visualization, testing, deployment, monitoring, documentation, stakeholder communication, and production support. • Build scalable, reusable, and well-documented data models using Snowflake SQL. • Ensure high data quality through automated validation and discrepancy resolution. • Collaborate with stakeholders to translate business needs into technical solutions using a modern data stack. • Develop, maintain, and document QA processes, incorporating automated testing. • Integrate agentic AI into daily workflows to optimize analytics and reporting results. • Code, test, and support BI systems, ensuring seamless cloud integration and performance. • Create interactive visualizations from multiple data sources that are intuitive, trusted, and designed to drive business action through clear insight and strong user experience. • Analyze large datasets to identify trends and generate predictive insights. • Create and maintain documentation for processes, tools, and content areas. Minimum Education and/or Experience: • BS in Computer Science, Information Systems, Engineering, Math, Analytics, or a related field, or equivalent practical experience. • Two or more years of experience developing BI, analytics, data, or reporting solutions, or demonstrated equivalent capability through relevant work, projects, or technical experience. • Experience using modern AI-assisted development tools, such as Snowflake Cortex, Claude Code, ChatGPT Codex, and Microsoft Copilot, to accelerate data analysis, code development, documentation, and visualization workflows. • Knowledge of the staffing industry and economic/market trends is a plus. Skills/Abilities: • Experience with Snowflake • Working knowledge of SQL and relational data concepts, including joins, filters, aggregation, data grain, and basic data-quality validation. • Familiarity with AI-assisted coding and Agentic AI for data analysis and visualization. • Strong analytical skills to translate business needs into technical solutions. • Working knowledge of Python; strong knowledge is a plus. • Experience in an Agile/SCRUM environment. • Excellent technical, organizational, and communication skills. • Ability to identify and automate test scenarios for system and user testing. • Skilled in troubleshooting code and data quality issues with diagnostic and monitoring tools. • Effective proactive communication of project status, issues, and resolutions to stakeholders. Benefits Overview: Benefits are subject to change and may be subject to specific elections, plan, or program terms. This role is eligible for the following: • Medical, dental & vision • Hospital plans • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Company paid Basic Life and AD&D as well as voluntary Life & AD&D for the employee and dependents) • Company paid Short and long-term disability • Health & Dependent Care Spending Accounts (HSA & DCFSA) • Transportation benefits • Employee Assistance Program • Tuition Assistance • Time Off/Leave (PTO, Allegis Group Paid Family Leave, Parental Leave) Salary Range: • $70,900 - $106,300 • The position is bonus eligible Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors. Office Requirements: • Required in office 4 days a week out of our headquarters in Hanover, MD Core Competencies: • Building Relationships • Develop People • Lead Change • Inspire Others • Think Critically • Communicate Clearly • Create Accountability “ Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors .” The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email Lauren Lara at llara@allegisgroup.com or call 410-579-3526 for other accommodation options.

Requirements

Must-haves

Build scalable, reusable, and well-documented data models using Snowflake SQL.
Ensure high data quality through automated validation and discrepancy resolution.
Collaborate with stakeholders to translate business needs into technical solutions using a modern data stack.
Develop, maintain, and document QA processes, incorporating automated testing.
Integrate agentic AI into daily workflows to optimize analytics and reporting results.
Code, test, and support BI systems, ensuring seamless cloud integration and performance.
Create interactive visualizations from multiple data sources that are intuitive, trusted, and designed to drive business action through clear insight and strong user experience.
Analyze large datasets to identify trends and generate predictive insights.
Create and maintain documentation for processes, tools, and content areas.
BS in Computer Science, Information Systems, Engineering, Math, Analytics, or a related field, or equivalent practical experience.
Two or more years of experience developing BI, analytics, data, or reporting solutions, or demonstrated equivalent capability through relevant work, projects, or technical experience.
Experience with Snowflake
Working knowledge of SQL and relational data concepts, including joins, filters, aggregation, data grain, and basic data-quality validation.
Familiarity with AI-assisted coding and Agentic AI for data analysis and visualization.
Strong analytical skills to translate business needs into technical solutions.
Experience in an Agile/SCRUM environment.
Excellent technical, organizational, and communication skills.
Ability to identify and automate test scenarios for system and user testing.
Skilled in troubleshooting code and data quality issues with diagnostic and monitoring tools.
Effective proactive communication of project status, issues, and resolutions to stakeholders.
Benefits are subject to change and may be subject to specific elections, plan, or program terms. This role is eligible for the following:
Medical, dental & vision

Nice-to-haves

Knowledge of the staffing industry and economic/market trends is a plus.
Working knowledge of Python; strong knowledge is a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaipythonagilescrum

Platform: icims
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Pto

Parental Leave