Data Systems Analyst

Trillium Staffing - North Providence, RI

Full-time - Mid Level

North Providence, RI

About the position

The SQL Developer will be responsible for analyzing data, working with software, and learning new technologies. This role involves collaborating with experienced leads and business resources to deliver quality solutions, including designing, implementing, and working in various systems.

Responsibilities

• Write complex SQL queries and develop complex PL/SQL objects, including DML and DDL.
• Perform database and SQL performance tuning.
• Utilize data modeling and data visualization tools, preferably Tableau or Power BI.
• Implement ETL practices using tools like Informatica or Pentaho.
• Manage and troubleshoot database management systems (DBMS).
• Debug and troubleshoot logical and functional coding errors.
• Document system architecture using Unified Modeling Language (UML).
• Collaborate with team members and communicate technical concepts clearly.

Requirements

• Minimum of 7 years of experience with Oracle databases.
• Strong experience with database and SQL performance tuning.
• Proficient in data modeling and data visualization tools.
• Working knowledge of ETL practices.
• Excellent understanding of database management systems (DBMS).
• Strong troubleshooting debugging skills with complex DML.
• Expert level SQL querying and database manipulation with very large data sets.

Nice-to-haves

• 5 years of Integrated Eligibility experience.
• Experience developing reports submitted to federal agencies (SNAP/TANF/Medicaid).
• Strong Data Validation, Quality Assurance, and Referential Integrity skills.
• Experience with Enterprise Workflow Management Tools such as JIRA and ServiceNow.
• Advanced understanding of Data Visualization Technologies such as Tableau.
• Oracle certification(s) are a plus.
• Familiarity with Agile methodologies, particularly Scrum, XP, and Kanban.
• Experience in XML, CSS, and JavaScript frameworks for web development.

Benefits

• Equal Opportunity Employer
• Commitment to honesty and integrity
• Focus on providing value to customers and employees