MS BI Developer

INSPYR Solutions; Plainsboro Township (NJ); On-site; USD 75,000 - 95,000; Full time

Benefits offered by this job

Comprehensive medical benefits

Competitive pay

401(k) retirement plan

Job summary

A technology talent solutions firm is seeking a Production Support Analyst to design and develop application programs. This hybrid role requires experience in SQL development and ETL solutions, and the ability to interact with internal business clients. You will be responsible for maintaining reports and ensuring the seamless transition from development to operations. Competitive pay and comprehensive medical benefits provided.

Qualifications

• Minimum two years' experience designing, developing, testing, and implementing ETL solutions.
• Proficiency in writing stored procedures, T-SQL/PL-SQL, functions, and SQL queries.
• Demonstrated proficiency in SQL development skills.

Responsibilities

• Design, develop, and maintain application programs.
• Develop reports using SQL queries to extract data.
• Collaborate with team members to prioritize work.

Skills

SQL development

ETL solutions design

Data integration

Report writing

Testing (UAT)

Problem-solving

Communication skills

Agile methodologies

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server Management Studio

Visual Studio Code

Power BI

SSRS

SSIS

Job description

Overview

Title: Production Support Analyst
Location: Hybrid in Princeton, NJ
Duration: 6+ month contract
Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S.

The Production Support Analyst is a position focused on designing, developing, enhancing, and supporting application programs and processes across the enterprise. This role requires interfacing with internal business clients to gather requirements, resolve issues, and provide subject matter expertise to assist with problem solving.

Responsibilities

• Design, develop, maintain, enhance and support application programs working within a team-oriented environment using various development toolsets.
• Developing reports using SQL queries/logic to extract data from SQL Server and Oracle databases, using application tools like SQL Server Management Studio and Visual Studio Code.
• Develop and maintain reports using Microsoft Power BI and SSRS.
• Provide support and monitoring of systems supporting business clients, occasionally after normal work hours.
• Facilitate requirements gathering efforts and clearly document system requirements.
• Develop new and enhanced system functionality including custom code and packaged application configuration.
• Ensure the successful transition from development to operations including operations procedures and tools such as process control points, reports, and automated monitoring.
• Regularly report status and raise issues/risks as appropriate. Anticipate and adjust for problems and roadblocks while eliminating roadblocks within control.
• Collaborate with team members and operational groups to identify and prioritize/reprioritize work when necessary.
• Develop strong working relationships with individuals at all levels of company, operations, and IT applications and infrastructure teams.
• Willingness to work hours as necessary, especially during critical issue resolution and milestone time periods.
• Interface with IT application owners and the IT organization to provide technical solutions to meet user needs. Escalate or resolve conflicts, as needed.
• Help identify and recommend options, risks and alternatives to deliver a robust and stable infrastructure.
• Devises or modifies procedures to solve problems considering computer equipment capacity and limitations, operating time, form of desired results, and integration of components.
• Assist in researching, evaluating, specifying and coding the configuration of hardware and/or software for application's environment.
• Requires skill and proficiency in many technical functions and ability to integrate across disciplines.
• Remain abreast of current technologies and best practices that may be applicable to the company.

Working Conditions

• Position is Hybrid full time
• Standard work week, with occasional overtime required.

Minimum Requirements

• Minimum two years' experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools (experience with SSIS is preferred)
• Minimum two years' experience developing and implementing data integration solutions in a SQL Server and/or Oracle database environment.
• Minimum two years' experience writing stored procedures, T-SQL/PL-SQL, functions, and SQL queries.
• Experience utilizing report writing best practices (optimization, use of joins and sub-queries)
• Experience with manual testing to include User Acceptance Testing (UAT)
• Experience with SQL Server Data Tools (SSDT) SSRS/SSIS/SSAS, Visual Studio, and/or other (non-Microsoft) reporting platform
• Minimum one year's experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment
• Proficiency estimating work assignments and delivering to these estimates
• Demonstrated proficiency of SQL development skills is required
• Understanding of SDLC and Agile Methodologies
• Understanding of ETL best practices

Additional Knowledge, Skills and Abilities

• Application configuration experience and testing experience.
• Experience writing C# and VB.net code is a plus
• Experience writing Python is a plus
• Knowledge of automation tools like Control M would be an additional asset
• Create and maintain technical documentation
• Experience working with end users, taking their business problems and translating them into system requirements.
• Configuration, testing, maintenance, enhancements and/or support activities.
• Perform ad hoc analysis, insight generation, and data migrations
• Evaluating user change requests and obtains approval to make modifications.
• Participating in project planning sessions with team members to analyze business and technical requirements.
• Conducting unit testing to ensure application meets specifications.
• Experience with energy business and systems that support retail energy is a plus.
• Knowledge of Software Configuration Management discipline and systems change management processes.
• Excellent verbal and written communication skills are required to provide appropriate cross functional support and interaction.
• Excellent troubleshooting and problem resolution skills
• Ability to work well under pressure, remaining focused and calm in the face of distractions, changing priorities in a fast-paced environment.
• Understanding of Relational Database concepts is a must
• Flexibility, dedication, and team spirit is a must
• Strong organizational skills.
• Strong analytical and problem-solving skills.
• Adept at communication, both verbally and written.

Benefits

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• …and much more!

About INSPYR Solutions

Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.