Software and Integration Developer chez CERTCO INC

Description

Software and Integration Developer

Location: Madison, WI Job Type: Full-time  

Schedule: Monday to Friday  Work Location: Madison, WI (Hybrid options available) 

Join a team that values innovation, collaboration, and growth.

Certco, Inc. — a leading grocery wholesale distributor headquartered in Madison, WI — is looking for a motivated and resourceful Software and Integration Developer to join our IT team.

This position combines software development and data integration expertise with strong Power BI development skills. The ideal candidate is someone who enjoys taking ownership of projects from concept through deployment, building scalable systems, and creating meaningful data-driven insights.

What You’ll Do

• Design, develop, and maintain Power BI dashboards and reports using DAX, Power Query (M), and data modeling best practices.
• Build and optimize SQL Server stored procedures and queries for performance and scalability.
• Develop and maintain ETL processes using SSIS or custom C# scripts.
• Build custom applications and APIs using C#, .NET Framework/Core, and REST services.
• Support and enhance interfaces for our Infor M3 cloud platform.
• Work collaboratively in an Agile/Scrum environment with analysts, DBAs, and business stakeholders.

What We’re Looking For

Required Skills & Experience

• Advanced experience with T-SQL / SQL Server (queries, stored procedures, performance tuning).
• Strong Power BI development skills (DAX, Power Query, data modeling).
• Hands-on experience with C# / .NET development.
• Familiarity with REST APIs and Git/GitHub for version control.
• Experience with ETL tools such as SSIS or custom scripting.
• Understanding of data warehousing and dimensional modeling concepts.

Preferred Skills

• Experience with Azure Data Services (Azure SQL, Data Factory, Synapse).
• Experience working in Agile/Scrum teams.

Education and Experience

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Science, MIS, or related field
  OR
• 3–5+ years of professional experience in software development or BI/data integration roles.

Why Join Certco?

At Certco, you’ll join a company that values its employees, invests in technology, and gives back to the community. We offer:

• Competitive pay and comprehensive benefits
• A supportive, collaborative work culture
• Opportunities for professional growth and skill development
• The chance to make a real impact through technology

Requirements

Position Summary

We are seeking a motivated and resourceful intermediate-level IT Software and Integration Developer to join our IT team. This role combines strong Power BI development and data integration expertise with software development capabilities. The ideal candidate will take ownership of projects from concept through deployment, contributing to both business intelligence initiatives and enterprise application development.

You will be responsible for designing and developing scalable software solutions, building and maintaining data pipelines, and creating impactful dashboards and reports. This includes working with Microsoft SQL Server, C#/.NET, REST APIs, and cloud-based platforms such as Azure. You’ll also support interface development and maintenance for our Infor M3 cloud solution.

Essential Job Junctions

Business Intelligence & Data Engineering

• Develop advanced Power BI dashboards and reports using DAX, Power Query (M), and data modeling best practices.
• Design and optimize SQL Server stored procedures and queries for performance and scalability.
• Build and maintain ETL processes using SSIS or custom C# scripts.
• Implement and support data warehouse structures (star/snowflake schemas, dimensional modeling).

Software Development & Integration

• Develop custom applications and APIs using C#, .NET Framework/Core, and Visual Studio.
• Consume and build REST APIs for system integration.
• Contribute to all stages of the software development lifecycle (SDLC).
• Write well-designed, testable code and prepare releases of software components.
• Ensure application designs align with business goals and technical standards.
• Maintain version control using Git/GitHub and follow CI/CD pipeline practices.
• Participate in Agile/Scrum development processes.

Required Skills

Business Intelligence and Data

• T-SQL / SQL Server: Advanced querying, stored procedures, performance tuning.
• SSRS (SSAS Optional) Needed for legacy and extended reporting environments.
• Power BI: Data modeling, DAX, report/dashboard development, Power Query (M language).
• ETL Processes: Experience with data extraction, transformation, and loading using tools like SSIS or custom C# scripts.
• Data Warehousing: Understanding of star/snowflake schemas, dimensional modeling.

Software Development

• C# / .NET Framework / .NET Core: For building custom applications, APIs, and integrations.
• Visual Studio: Primary IDE for development and debugging.
• REST APIs: Consuming and building APIs for data integration.
• Git / GitHub: Version control, branching strategies, pull requests.

Tooling & Platforms

• Azure Data Services (optional but valuable): Azure SQL, Data Factory, Synapse, etc.
• Maintain and enhance interfaces with Infor M3 cloud solutions.

Competency

• Analytical Thinking: Ability to think logically and translate business needs into technical solutions.
• Agile/Scrum: Experience working in iterative development environments.
• Collaboration: Working with cross-functional teams including analysts, DBAs, and business stakeholders.
• Documentation: Writing clear technical documentation and data dictionaries.

Education and Experience

Bachelor’s degree in one of the following (or related) fields:

• Computer Science
• Information Technology
• Software Engineering
• Data Science
• Management Information Systems (MIS)
  OR
  3–5+ years of professional experience in software development or BI/data integration roles

Proven experience with

• Microsoft SQL Server and T-SQL (complex queries, stored procedures, performance tuning).
• Power BI (end-to-end report/dashboard development, DAX, data modeling).
• C# / .NET development in enterprise environments.
• Version control systems like Git/GitHub.
• ETL processes using tools like SSIS or custom scripting.

Preferred Experience

• Experience with Azure Data Services (e.g., Azure SQL, Data Factory).
• Working in Agile/Scrum teams.
• Exposure to data warehousing and dimensional modeling.

Certco is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.