•**Only qualified Senior Data Analyst candidates located near the Everett, MA area to be considered due to the position requiring an onsite presence***

Required qualifications:

Understand data warehouse concepts and needs

Expert knowledge of databases, Snowflake a plus, also Oracle and SQL Server

Excellent communication skills with a demonstrated ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally

Strong attention to detail and troubleshooting skills for QA; able to identify errors/discrepancies, isolate the cause, apply solutions and validate the resulting data

Experience with dimensional modeling and knowledge of proper data structures for analytical reporting from an enterprise data warehouse

Good knowledge of applicable data privacy when handling sensitive personal information

Team player who enjoys being part of a supportive team, with a willingness to learn and share knowledge among team members

Preferred qualifications:

Experience using database reporting tools such as Power BI and Tableau

Experience using data cataloging tools such as Alation and Socrata

Experience mentoring other analysts and teaching SQL

Confidence recommending policies and procedures to improve database operations and overall computer systems efficiency

Ability to diagram complex data structures

Ability to perform tasks such as analyzing, moving, and loading data, as well as developing T-SQL, PL/SQL, ANSI SQL, or other proprietary SQL languages

Responsibilities:

Collaborate with business research analysts to identify data needs

Create and document data marts and queries for business data needs, ensuring that resulting data match existing reports with fidelity

Write and review documentation to contribute to a business rules data handbook, capturing data rules in user-friendly language

Reverse engineer schemas and queries using available tools and methodologies, with the goal of understanding and documenting business rules that are applied in existing data loading processes

Translate complex problems into detailed specifications and design solutions using data processing systems

Create and maintain entity-relationship diagrams (ERDs) and perform database modeling, including logical, physical, and presentation tiers

Provide technical and database support for in-house applications, ensuring optimal performance and user satisfaction

Contribute to the knowledge base, sharing best practices and lessons learned with the Edwin team

Maintain code in GitHub, ensuring proper version control and adherence to coding standards

Accurately and promptly log all work, including estimates and time spent, in JIRA

Facilitate the adoption of efficient coding practices and innovative solutions

**Only those lawfully authorized to work in the designated country associated with the position will be considered.**

**Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**

Benefits:

For information and details on employment benefits offered with this position, please visit

here

. Should you have any questions/concerns, please contact our HR Department via our secure

website

.

California Pay Equity:

For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website

here

.

Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.

If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise,

please contact our HR Department

.

Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).