Senior Data Analyst

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.).