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 endtoend data workflows, contribute to technical design, and collaborate closely with crossfunctional partners to deliver highquality, 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 handson 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, problemsolving, 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.

Preferred Qualifications

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

Soft Skills

• Strong analytical and problemsolving 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