Database Analyst IV - Microsoft SQL Server, BI

GlobalPoint Inc; United States; Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Database Analyst IV to join their remote team. This role involves developing database structures, ensuring compliance with federal regulations, and collaborating with various teams to manage database changes. With a focus on Microsoft SQL Server and Business Intelligence, the ideal candidate will have extensive experience in data analysis and a strong understanding of security protocols. This is a long-term contract opportunity that offers the chance to work in a dynamic environment where your contributions will directly impact the efficiency and effectiveness of vital information systems.

Qualifications

• 7-9 years of experience with Microsoft SQL Server and Reporting Services.
• 10+ years of experience in Data Analysis and SQL.

Responsibilities

• Develop database structure and process changes based on specifications.
• Ensure compliance with data security and access models.

Skills

Microsoft SQL Server

Transact-SQL

Data Analysis

JSON

C#

JavaScript

HTML DOM

Communication skills

Tools

Microsoft Visual Studio

Microsoft .NET framework

Microsoft Azure Development Operations

Job description

Database Analyst IV - Microsoft SQL Server, BI

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

Role: Database Analyst IV - Microsoft SQL Server, BI
Duration: Long Term Contract
Work Type & Location: Remote - Salem, OR 97302

Key Responsibilities

• Develop database structure and process changes based on specifications established during weekly Sprint planning sessions and following data standards, including those published by the United States Postal Service where appropriate.
• Ensure compliance with data security and access models.
• Adhere to Federal regulations for CCWIS (Comprehensive Child Welfare Information System) design, development, deployment, and maintenance.
• Follow a change request process for database modifications in collaboration with developers and Data Resource Management teams.

Required Skills and Experience

• Microsoft SQL Server/Reporting Services/Business Intelligence (7-9 years)
• HTML DOM (7-9 years)
• Windows 9x/2000/XP/NT/Vista/7 (7-9 years)
• Transact-SQL (10+ years)
• Microsoft Visual Studio (10+ years)
• Microsoft .NET framework (4-6 years)
• Microsoft Azure Development Operations
• MVC (4-6 years)
• Data Analysis (10+ years)
• JSON (10+ years)
• SQL (10+ years)
• XML (4-6 years)
• C# (4-6 years)
• JavaScript (4-6 years)
• TCP/IP (4-6 years)
• Communication skills (verbal and written, 4-6 years)
• Microsoft Office (4-6 years)

Preferred Additional Skills

• Experience with SDLC, especially regarding requirement changes
• Agile development processes
• Requirements elicitation and collaboration with non-technical staff
• Experience with modernization initiatives in Federal programs
• Working in Human Services contexts
• Managing database change impacts on external data exchanges or data warehouses

Candidate Experience Matrix

Category	Qualification	Competency	Required
Architecture	Microsoft .NET Framework	Proficient (4-6 Years)	Yes
Architecture	MVC	Proficient (4-6 Years)	Yes
Architecture	Service-oriented architecture (SOA)	Proficient (4-6 Years)	Yes
Architecture	XMLSchema	Proficient (4-6 Years)	No
Database	Microsoft SQL Server	Expert (10+ Years)	Yes
Languages	C#	Proficient (4-6 Years)	No
Languages	HTML	Proficient (4-6 Years)	Yes
Languages	JavaScript	Proficient (4-6 Years)	Yes
Languages	JSON	Proficient (4-6 Years)	Yes

Additional Details

• Seniority Level: Associate
• Employment Type: Full-time
• Job Function: Information Technology
• Industries: IT Services and IT Consulting