The Data Analyst II reports to the Senior Data Analyst and the Programming Department Software Development Manager.
The position is located at 500 Steed Road, Ridgeland MS 39157.

GENERAL JOB DUTIES AND RESPONSIBILITIES:

The Data Analyst II will work under the supervision of the Lead Data Analyst. This is a mid-senior level role.
Assigned work will help to broaden the DAII's experience and increase SQL skills.
To perform the job successfully, the employee must be able to perform each essential duty satisfactorily.
The requirements listed here are representative of the knowledge, skill, and ability required.
Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Design, develop, and maintain both new and existing SQL queries using SQL Management Studio.

Design, implement and maintain ETL workflows to extract, transform and load data from multiple sources into reporting and analytics environment.
Collaborate with data engineers and developers to optimize ETL pipelines for performance, scalability and reliability.
Ensure data integrity, accuracy and completeness throughout the ETL process.
Design, develop and maintain SQL queries, views and stored procedures using SQL Server Management Studio to support reporting and analytical needs.
Create and maintain advanced, reusable reporting solutions to deliver actionable insights for business stakeholders.
Translate business and technical requirements into accurate, production-ready reports and dashboards, ensuring alignment with organizational objectives.
Conduct continuous report reviews to eliminate redundancy, improve data quality and consolidate reporting into a single source of truth.
Work closely with QA teams to validate data accuracy and ensure that reporting deliverables meet quality standards.
Partner with cross-functional teams to understand business processes and translate them into data solutions.
Support the software development lifecycle by providing timely, accurate and relevant reporting for product and operational initiatives.
Maintain a centralized repository of reusable reports and analytic assets via Microsoft DevOps.
Provide guidance and mentorship to junior analysts, fostering skill development in Power BI, SQL and ETL tools.
Contribute to the design, review and configuration of analytics applications and reporting solutions to meet evolving business needs.

EXPERIENCE AND EDUCATION REQUIREMENTS:

The ideal candidate for this position would have the following required experience as follows:

Bachelor's degree in a Computer Science, Information Systems, Data Analytics or related field or equivalent work experience.
Proficiency at writing SQL queries and validating SQL query results.
Creating complex DEX measures and calculated columns.
Understanding of Data Visualizationbest practices.
Advanced understanding of the ETL processbest practices.
Must be able to independently solve technical problems and collaborate with other analysts.
Must have the capacity to complete technically challenging projects.
Must have a solid understanding of the System Development Life Cycle and the SCRUM methodology.
Must understand HIPAA rules that apply to dealing with sensitive data.
The ideal candidate for this position would have the following preferred experience as follows:
At least 4 years of experience working with large-scale relational databases (SQL Server, Oracle, MSQLAccess).
At least 4 years developing SQL queries.
At least 4 years of experience using reporting tools to present data.
Experience using Microsoft Business Intelligence (SSIS, SSRSSSAS)
Experience with data visualization tools (Power BI, Spotfire, Tableau, etc.)

WORKING ENVIRONMENT:

Must have the ability to work independently while practicing effective time management skills.
Must be able to prioritize work on multiple projects and meet project deadlines in an organized manner.
Must possess excellent problem-solving skills and have keen attention to details.
Strong written and verbal communication, interpersonal, and relationship building skills are required.
Must be able to handle high priority time sensitive work items.

JOB ESSENTIAL REQUIREMENTS:

The following are job functions that an employee must be capable of performing with or without reasonable accommodation.

Must be able to read, write, and speak English; Spanish is a plus.
Must have basic typing skills
Must be able to work as scheduled.
Must possess sight and hearing senses or use prosthetics that will enable these senses to function adequately so that the requirements of the position as stated above can be fully met.
Must be able to bend, stretch, reach, and sit or stand at a desk during 85% of the workday.
Must be able to lift, stoop, and carry small equipment items and supplies, possibly weighing up to 20lbs.

MWG is an Equal Opportunity Employer, committed to the principles of the EEOC. All employment decisions are based upon each person's qualifications, abilities, and performance.
Our company works to provide an environment where human dignity prevails and all employees and applicants for employment receive equal consideration and fair treatment, without regard to race, color, religion, age, sex, national origin, disability status,
genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Morgan White Group

Latest Jobs

Data Analyst II