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 mid‑level 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. Responsibilities 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 Skills / Requirements Bachelor’s 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. 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 enterprise‑scale BI or analytics solutions DP-600 or DP-700 Microsoft Fabric certification is a plus. Soft Skills Strong analytical and problem‑solving skills. Excellent communication and ability to work with both technical and non‑technical teams. Proactive ownership mindset and commitment to continuous improvement. Note: All offers are contingent upon successful completion of a background check *Posted positions are not open to third party recruiters and unsolicited resume submissions will be considered free referrals. AGS is an equal opportunity employer. #J-18808-Ljbffr