What are the responsibilities and job description for the Data Systems Analyst position at Trillium Staffing?
Our client is looking for a SQL Developer who has a passion for analyzing data, working with software and learning new technologies. The developer will be working directly with experience leads, and business resources to deliver quality solutions. You will be involved with designing, implementing and working in various systems.
Required Skills :
- Database and Programming Proficiency :
- Minimum of 7 years of experience with Oracle databases, capable of writing complex SQL queries and developing complex PL / SQL objects, including DML and DDL.
- Strong experience with database and SQL performance tuning.
- Proficient in data modelling and data visualization tools (Preferred Tableau / Power BI)
- Working knowledge of ETL practices (Extract, Transform, and Load) (Preferred - Informatica, Pentaho)
- 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
- Ability to debug and troubleshot logical and functional coding errors
- Development Tools and Methodologies :
- Familiarity with code repositories, ideally Git.
- Experience with continuous integration tools, preferably Jenkins.
- Knowledge of relational database designs, ISDM methodologies, database security (role-based), and query tools like TOAD, SQL -Developer, or SQL Navigator.
- Technical and Analytical Skills :
- Proficiency in Unified Modeling Language (UML) for documenting system architecture.
- Ability to solve complex problems creatively and anticipate issues with software designs or specifications.
- Excellent interpersonal skills to establish effective working relationships, collaborate with team members, and communicate technical concepts clearly.
If interested, please apply today!
Preferred Knowledge, Skills & Abilities :
Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same : to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.
