Careers
Added Oct 01, 2024
Software Engineer IV
(26521)
Kansas City, MO
|
Temp to Perm
Apply
For additional information on how we handle your data, see www.LRS.com/privacy
Job Description
LRS Consulting Services is thrilled to announce an exceptional direct hire opportunity for a Software Engineer IV with our esteemed client based in vibrant Kansas City, MO. This role offers the perfect blend of flexibility, allowing you to work remotely only going in as needed.
Position Summary:
The Software Engineer is responsible for designing reporting and data integration processes using SQL, MS SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). The position will also entail some API work in C# that will integrate with SQL objects. This role will partner with other team members and business stakeholders to deliver reporting and analytical solutions.
Expectations:
- Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and
production configuration
- Enforce uniform adherence to established standards and procedures for the department. Review documentation submitted by programmers to ensure conformity to
standards.
- Ensure that each data flow has robust audit, data validation, error handling, monitoring and reporting steps to ensure accuracy and completeness of loaded data at
all times
- Provide accurate effort estimates to the Team Lead and/or Project Manager and project teams as appropriate
- Deliver testing support including the design and execution and documentation of test scripts
- Strong analytical and problem-solving skills
- Strong communication, presentation, and relationship management skills
- Experience working in a team-oriented, collaborative environment
- Ability to work with diverse teams
- Ability to maintain confidentiality
- Performs other related duties as assigned and required
Competencies:
- Skills and hands-on experience of the following:
- SQL (Microsoft SQL Server) including experience with CTE’s and temporal tables
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
- Experience documenting and following specifications and challenging business logic where appropriate
- Experience with application development using C# or .NET
- Experience writing/debugging APIs
- Experience with Data Factory is a plus
- Experience with the Insurance industry is a plus
- Microsoft certifications related to SQL Server and Data are a plus
- Understanding of Accounting is a plus
Requisites:
-Bachelor’s Degree or equivalent work experience in the data warehouse field
- SQL development in SQL Server 2014 and above – 5+ years
- SSRS reports in SQL Server 2014 and above – 5+ years
- SSIS development in SQL Server 2014 and above – 5+ years
-Developing data integration and ETL solutions
- C# – 1+ year
- .NET – 1+ year
- APIs and Web services – 1+ year
- Great understanding of databases and data processing
- General knowledge of SCRUM methodology
- Good understanding of business requirements gathering and documentation solutions with personalized expertise and responsiveness
LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.
#LI-DS1
Position Summary:
The Software Engineer is responsible for designing reporting and data integration processes using SQL, MS SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). The position will also entail some API work in C# that will integrate with SQL objects. This role will partner with other team members and business stakeholders to deliver reporting and analytical solutions.
Expectations:
- Analyze, define, and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements, and
production configuration
- Enforce uniform adherence to established standards and procedures for the department. Review documentation submitted by programmers to ensure conformity to
standards.
- Ensure that each data flow has robust audit, data validation, error handling, monitoring and reporting steps to ensure accuracy and completeness of loaded data at
all times
- Provide accurate effort estimates to the Team Lead and/or Project Manager and project teams as appropriate
- Deliver testing support including the design and execution and documentation of test scripts
- Strong analytical and problem-solving skills
- Strong communication, presentation, and relationship management skills
- Experience working in a team-oriented, collaborative environment
- Ability to work with diverse teams
- Ability to maintain confidentiality
- Performs other related duties as assigned and required
Competencies:
- Skills and hands-on experience of the following:
- SQL (Microsoft SQL Server) including experience with CTE’s and temporal tables
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- The ability to work accurately and diligently under pressure, on multiple projects within your project timeframes
- Experience documenting and following specifications and challenging business logic where appropriate
- Experience with application development using C# or .NET
- Experience writing/debugging APIs
- Experience with Data Factory is a plus
- Experience with the Insurance industry is a plus
- Microsoft certifications related to SQL Server and Data are a plus
- Understanding of Accounting is a plus
Requisites:
-Bachelor’s Degree or equivalent work experience in the data warehouse field
- SQL development in SQL Server 2014 and above – 5+ years
- SSRS reports in SQL Server 2014 and above – 5+ years
- SSIS development in SQL Server 2014 and above – 5+ years
-Developing data integration and ETL solutions
- C# – 1+ year
- .NET – 1+ year
- APIs and Web services – 1+ year
- Great understanding of databases and data processing
- General knowledge of SCRUM methodology
- Good understanding of business requirements gathering and documentation solutions with personalized expertise and responsiveness
LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.
#LI-DS1