Software Developer - Database L2

$78,125 - $122,075/Yr

Capgemini - Woodland, CA

Full-time - Mid Level

Woodland, CA

Professional, Scientific, and Technical Services

About the position

The Software Developer - Database L2 position at Capgemini involves developing advanced Business Intelligence (BI) applications using the Microsoft BI stack. The role focuses on designing, building, and maintaining complex ETL packages, as well as creating and supporting OLAP/SSAS cubes for reporting needs. This position requires a strong proficiency in SQL programming and T-SQL, along with experience in Power BI for report creation.

Responsibilities

• Develop advanced BI applications using the MS BI stack including SSAS and SSIS.
• Design, build, and maintain complex ETL packages.
• Create and support OLAP/SSAS cubes for reporting needs.
• Build stored procedures, functions, and packages as well as MDX.
• Maintain production support and steady state by job runs based on schedules.

Requirements

• 6-8 years of experience in software development.
• Proficiency in SQL programming and T-SQL.
• Strong knowledge of database design, data modeling, query optimization, and data analysis.
• Experience with SSIS package development and deployment, debugging, and troubleshooting.
• Experience in creating Power BI reports using Power BI Desktop and Report Builder.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Retirement benefits