Data Analyst

Mbi Llc; Trenton (NJ); On-site; USD 85,000 - 120,000; Full time

Job summary

Mbi Llc in New Jersey is seeking a Data Analyst to drive technical analysis, automation, and fulfillment of enterprise data requests within the department's digital infrastructure. The role emphasizes Snowflake SQL and Python to manage complex data workflows in a cloud AWS environment, auditing existing code, optimizing automations, and ensuring data integrity across the Project Nexus ecosystem.

You'll act as the technical point of contact for complex inquiries, translating business needs into

Qualifications

• Snowflake SQL scripting and optimization expertise.
• Python programming for data automation.
• Data analysis and profiling skills.
• Automated scripting for ticket resolution and automation.
• Cloud data warehouse experience (AWS).

Responsibilities

• Develop and optimize Snowflake SQL scripts to fulfill ad-hoc data requests.
• Audit and optimize existing Python and SQL code to improve automation.
• Automate data-related tickets using Python to reduce manual work.
• Profile data and validate data in Snowflake and AWS for data integrity.
• Serve as technical contact translating business needs into deliverables.

Skills

Snowflake SQL (Scripting & Optimz)

Job description

• The Data Analyst is responsible for the technical analysis, automation, and fulfillment of enterprise data requests within the Department's digital infrastructure.
• This role requires a high degree of proficiency in Snowflake SQL and Python to manage complex data workflows.
• The Analyst will be responsible for not only writing new scripts to automate ticket resolutions but also for auditing, understanding, and optimizing existing codebase to ensure system continuity.
• Working within cloud environments (Snowflake/AWS), the analyst will execute complex data requests, perform deep-dive profiling, and resolve data discrepancies to support the Department's modernization initiatives.
• Snowflake SQL Development: Write, debug, and optimize complex SQL scripts within the Snowflake environment to fulfill ad-hoc data requests and perform system-wide data analysis.
• Codebase Auditing: Review and interpret existing Python and SQL code to troubleshoot errors, suggest improvements, and ensure new automations align with established logic.
• Support Automation: Develop and deploy Python-based scripts to automate the resolution of recurring support tickets, significantly reducing manual intervention for common data tasks.
• Cloud Data Operations: Perform data profiling and validation within Snowflake and AWS to ensure data integrity across the Project Nexus ecosystem.
• Request Fulfillment: Serve as the technical point of contact for complex data inquiries, translating business requirements into precise technical deliverables.

Fill the skill matrix below:

Skill

Amount

Candidate's No. of years of experience

Snowflake SQL (Scripting & Optimization)

Required

3

Python Programming (Data/Automation)

Required

3

Required

3

Data Analysis & Profiling

Required

3

Automated Scripting for Ticket Resolution

Required

3

Required

3

Cloud Data Warehouse (AWS)

3