ETL/Data Support Analyst

Primary Services; Town of Texas (WI); Remote; USD 75,000 - 100,000; Full time

Job summary

A leading company in the energy sector is looking for an ETL/Data Support Analyst to work remotely. This role will involve leveraging SQL development expertise and providing application support within a collaborative environment. Responsibilities include designing integration solutions and maintaining application functionalities to meet business needs.

Benefits

Medical insurance

Vision insurance

401(k)

Qualifications

• Minimum 2 years of experience with ETL solutions.
• Proficient in writing stored procedures and SQL queries.
• Experience with SQL Server Data Tools and high-volume data exchange.

Responsibilities

• Design and support application programs within a team.
• Create and maintain reports using SQL Server Management Studio.
• Facilitate requirements gathering and document detailed system requirements.

Skills

SQL development

Application support

Data integration solutions

T-SQL

Software Development Life Cycle

Agile methodologies

Technical documentation

Tools

SQL Server Management Studio

SSRS

SSIS

Visual Studio

Job description

Join a Fortune 200 company and advance your career while enjoying the flexibility of a fully remote role. Work alongside industry experts on innovative projects that support critical business applications in a dynamic energy sector environment.

Primary Services is actively recruiting for an ETL/Data Support Analyst to support a large, well-established client in the energy industry. This role offers an excellent opportunity to leverage your experience in SQL development, application support, and reporting within a collaborative, technology-driven setting. You will play a key role in designing, developing, and maintaining application programs and data integration solutions that support business needs.

Responsibilities:

• Design, develop, enhance, and support application programs within a team environment using various development tools.
• Create and maintain reports using SQL Server Management Studio, Power BI, and SSRS.
• Provide system support and monitoring, occasionally outside normal business hours.
• Facilitate requirements gathering and document detailed system requirements.
• Develop new system functionality including custom code and packaged application configurations.
• Ensure smooth transition from development to operations with appropriate procedures and monitoring tools.
• Communicate project status, identify risks, and proactively resolve roadblocks.
• Collaborate with IT and business teams to prioritize workload and adjust to changing demands.
• Interface with IT application owners to provide technical solutions aligned with business needs.
• Research, evaluate, and implement software and hardware configurations for optimal application performance.
• Stay current with emerging technologies and best practices relevant to the business and IT environment.

Qualifications:

• Minimum 2 years experience designing, developing, testing, and implementing ETL solutions; experience with SSIS preferred.
• Minimum 2 years developing and implementing data integration solutions in SQL Server environments.
• Proficient in writing stored procedures, T-SQL, functions, and SQL queries with report writing best practices.
• Experience with SQL Server Data Tools (SSDT), SSRS, SSIS, SSAS, and Visual Studio or similar platforms.
• At least 1 year experience with high-volume data exchange and transaction processing systems.
• Knowledge of Software Development Life Cycle (SDLC) and Agile methodologies.
• Understanding of ETL best practices.
• Application configuration and manual testing experience, including User Acceptance Testing (UAT).
• Familiarity with relational database concepts is essential.

Additional assets:

• Experience with C# and VB.net coding.
• Knowledge of automation tools such as Control M.
• Background in energy business systems, particularly retail energy, is a plus.
• Strong technical documentation and troubleshooting skills.

Want to be notified of similar positions? Visit www.primaryservices.com/signup/ to sign up and have notifications delivered straight to your inbox!

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Analyst and Information Technology

• Industries

  Utilities and Electric Power Generation

Referrals increase your chances of interviewing at Primary Services by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Get notified about new Support Analyst jobs in Texas, United States.

e-Service Chat Representative - 100% Remote

administrative assistant sr, Northeast (Remote - U.S.)

Girlstown USA, TX $28.65-$48.61 2 weeks ago

Dallas, TX $50,000.00-$60,000.00 1 day ago

Technical Support Analyst / Customer Support Rep | 100% Remote | Perfect Engilsh Required | Construction SaaS | CLUE (getclue.com)

Implementation Specialist (Remote Position)

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