Senior Data Analyst

Job#: 2041042

Job Description:

Job Title: SQL Data Analyst
Location: Metairie, Louisiana (must be local)
Duration: 6 month contract to hire 
Compensation: Competitive + benefits on W2
Work Authorization: we cannot provide sponsorship for this position *** must be able to work on W2 
please apply directly by emailing your resume and a brief write up of why you are a fit to [email protected]
 

Position Overview: We are seeking a skilled SQL Data Analyst to join our team. The ideal candidate will have a strong background in SQL administration, report building, and data integration. This role involves working closely with end users to design, automate, and validate reports, ensuring data accuracy and efficiency.

Key Responsibilities:

• SQL Administration: Manage and maintain SQL databases, including T-SQL (Transact-SQL) tasks.
• Report Building: Develop and deliver reports using SQL data, integrating them into Excel and Power BI.
• Data Integration: Build and maintain tables, integrating various data sources into the Datawarehouse.
• Report Design: Design reports in SQL, outputting to Power BI and Excel, and automate these processes.
• User Collaboration: Work with end users to understand their data needs and deliver customized reports.
• Automation: Ensure all reports are automated, including error checking and validation.
• Maintenance: Perform regular maintenance on data and reports, ensuring data integrity.
• Datawarehouse Development: Collaborate with the team to build out the Datawarehouse.
• System Integration: Work with the Sage system for data integration and reporting.

Top 3 Must-Have Technologies/Experience:

1. Automation: Experience with EDI automation and the ability to integrate external data sources into SQL.
2. SQL Proficiency: Ability to develop SQL data into presentable formats in Excel and Power BI, including building efficient queries with multiple data sets.
3. Stored Procedures: Experience in building and scheduling stored procedures.

Nice to Haves:

• Analytical Skills: Strong analytical skills to interpret data and create meaningful reports.
• Testing Experience: Experience in designing test scripts and performing end-to-end testing.
• Power BI/DAX: Proficiency in developing SQL data into presentable formats using Power BI and DAX.

Additional Skills:

• SQL Server Administration: Manage and maintain SQL Server environments.
• Automation Skills: Ability to automate data processes and integrate external data sources.
• Report Design: Design reports from input to output using various automation methods.
• Business Process Understanding: Apply business process knowledge to create accurate reports.
• Validation and Error Reporting: Design automated validations and error reporting for reports.
• Revision Control: Implement good revision control techniques with clear code explanations.
• EDI Experience: Experience with EDI and EDI automation.

If you have a passion for data, strong SQL skills, and the ability to automate and validate reports, we encourage you to apply for this exciting opportunity.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.