Software Engineer II- BI

Position Title: Software Engineer II- BI

AGS is seeking Software Engineer II Business Intelligence to join our R&D BI team in Duluth, GA. This is a full-time on-site role where you will design, build, and operate scalable data and analytics solutions that deliver trusted insights to the business. As a midlevel engineer, you will work on end-to-end data workflows, contribute to technical design, and collaborate closely with cross-functional partners to deliver high-quality, maintainable solutions using modern Microsoft data and analytics technologies.

• Design, implement, and maintain ELT pipelines using SSIS, Microsoft Fabric Data Pipelines, and related tooling
• Build and optimize semantic models for analytical and reporting workloads
• Create data transformation using tools like Py-Spark and Notebook
• Develop efficient and scalable SQL queries, views, and stored procedures
• Develop and support services and components using C#
• Participate in technical design discussions, code reviews, and solution architecture decisions
• Partner with business stakeholders, analysts, and engineers to translate requirements into implemented solutions
• Monitor, troubleshoot, and resolve data quality, performance, and pipeline issues
• Contribute to documentation, standards, and reusable patterns across the BI platform

• Bachelors degree in computer science, Information Technology, Engineering, or a related field
• 3+ years of hands-on industry experience in Business Intelligence, Data Engineering, or related roles
• Strong experience with ELT tools, including SSIS and modern data pipelines
• Proficiency in SQL (query optimization, complex joins, performance tuning)
• Working knowledge of C#
• Experience with Microsoft Fabric, Power BI, Notebook and Py-Spark
• Strong knowledge about setting up connections and credentials in MS Fabric.
• Strong analytical, problem solving, and debugging skills
• Excellent verbal and written communication skills
• Ability to work effectively both independently and within a team environment
• Good understanding of One Lake, medallion architecture, semantic modeling, and data governance.
• Good understanding of AI integration, semantic models for AI and tools like Microsoft Copilot.

• Experience with Dev Ops practices, including CI/CD pipelines
• Familiarity with source control systems (Git, SVN, Azure Dev Ops, etc.)
• Exposure to cloud data platforms and modern data architecture
• Experience supporting enterprise-scale BI or analytics solutions
• DP-600 or DP-700 Microsoft Fabric certification is a plus.

• Strong analytical and problem solving skills.
• Excellent communication and ability to work with both technical and nontechnical teams.
• Proactive ownership mindset and commitment to continuous improvement.

Note:

All offers are contingent upon successful completion of a background check.

AGS is an equal opportunity employer.

Equal Opportunity Employer, including disability/protected veterans

Equal employment opportunity, including veterans and individuals with disabilities.