MS BI Developer

INSPYR Solutions; Huntersville (NC); Remote; USD 80,000 - 110,000; Full time

Job summary

INSPYR Solutions recherche un MS BI Developer pour un contrat de 6 mois en télétravail. Le candidat idéal aura une solide expérience en développement ETL et SQL, ainsi qu'une aptitude à travailler efficacement en équipe. Ce rôle inclut des responsabilités dans la conception et le support de rapports, en utilisant des outils comme Power BI et SQL Server. Les candidats doivent avoir d'excellentes compétences en communication et une compréhension des méthodologies Agile.

Benefits

Comprehensive medical benefits

Competitive pay

401(k) retirement plan

Qualifications

• Minimum 2 ans d'expérience en développement SQL et ETL.
• Connaissance des outils Microsoft (SSIS, SSDT, Power BI).
• Compétences avérées en documentation et tests UAT.

Responsibilities

• Développer des rapports et des solutions d'intégration de données.
• Assurer le support des systèmes et documenter les exigences.
• Coordonner la transition des développements vers les opérations.

Skills

SQL Development

Data Integration

ETL Processes

Reporting

Documentation

Tools

SQL Server Management Studio

Power BI

SSRS

Visual Studio

Job description

Get AI-powered advice on this job and more exclusive features.

Role: MS BI Developer
Location: Remote
Duration: 6+ month contract
Work Authorization:We are able to include US Citizen, GC Holders or Authorized to Work in the US. W2/Direct employment only.

Essential Duties/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 databases, using application tools like SQL Server Management Studio.
• 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.


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 database environment.
• Experience writing stored procedures, T-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 years' 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
• 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 in order 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

Our benefits package includes:

• 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Construction and Oil and Gas

Referrals increase your chances of interviewing at INSPYR Solutions by 2x

Get notified about new Business Intelligence Developer jobs in Huntersville, NC.

Analyst Data Analytics - US Based Remote

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.