Senior data analyst Job at CompuVision Consulting, Inc., Everett, MA

MWpBK1NvZGt0NkU4U0I1a3FVVk0vV2o1VUE9PQ==
  • CompuVision Consulting, Inc.
  • Everett, MA

Job Description

Job Title: Senior Data Analyst
Duration: 12 months
Location: Everett, MA (Hybrid)

Summary:

The Senior Data Analyst will be instrumental in supporting the Education-to-Career (E2C) initiative by enhancing equitable access to data through Edwin, the state s education data warehouse. This role requires a strong technical background combined with the ability to effectively interpret and communicate data insights. The position necessitates close collaboration with data architects and BI developers to expand Edwin and optimize reporting tools.

Duties and Responsibilities:

  • Partner with business research analysts to evaluate and define data requirements.
  • Design and document data marts and queries to meet business needs, ensuring data accuracy and alignment with existing reports.
  • Develop and maintain a business rules data handbook by drafting and reviewing documentation in clear, accessible language.
  • Reverse engineer data schemas and queries to understand and document business rules used in existing data loading processes.
  • Translate complex data challenges into detailed specifications and design suitable solutions using data processing systems.
  • Create and manage entity-relationship diagrams (ERDs) and engage in database modeling across logical, physical, and presentation tiers.
  • Provide technical and database support for internal applications, ensuring high performance and user satisfaction.
  • Contribute to the team s knowledge base by sharing best practices and lessons learned.
  • Maintain code in GitHub, ensuring proper version control and adherence to coding standards.
  • Log all work accurately in JIRA, including time estimates and actual time spent.
  • Advocate for and implement efficient coding practices and innovative solutions.

Required Qualifications:

  • Comprehensive understanding of data warehouse concepts and requirements.
  • Expertise in database management, with hands-on experience in Snowflake, Oracle, and SQL Server.
  • Exceptional communication skills, with the ability to clearly convey technical concepts to both technical and non-technical audiences, both in writing and verbally.
  • Strong attention to detail and troubleshooting skills for quality assurance, including the ability to identify, isolate, and resolve errors or discrepancies.
  • Experience in dimensional modeling and knowledge of data structures for enterprise-level analytical reporting.
  • Understanding of data privacy regulations and best practices for handling sensitive personal information.
  • Proven ability to work effectively in a team environment, with a willingness to learn and contribute to the team.

Preferred Qualifications:

  • Experience with data reporting tools such as PowerBI and Tableau.
  • Familiarity with data cataloging tools such as Alation and Socrata.
  • Experience in mentoring analysts and providing SQL training.
  • Confidence in recommending and implementing policies and procedures to enhance database operations and system efficiency.
  • Proficiency in diagramming complex data structures.
  • Skills in data analysis, migration, and loading, with experience in developing T-SQL, PL/SQL, ANSI SQL, or other proprietary SQL languages.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Report this job
  • Dice Id: 10468931
  • Position Id: SDA24-13245

Job Tags

Contract work,

Similar Jobs

FMHC

Senior Internal Auditor Job at FMHC

 ...Description: The Internal Auditor Senior is responsible for evaluating and reporting on the effectiveness of internal controls, as...  ...and Experience # Education: Bachelor's degree in Accounting or Finance is required: Master's degree is preferred. # Certification: None... 

National Kidney Foundation

Executive Director Job at National Kidney Foundation

 ...community Compassion- Lead with care and respect Impact-Focus on the mission Your Voice Matters: WHAT YOULL DO The Executive Director is responsible for running all aspects of the business for the NKF Market area to include North Carolina and South Carolina.... 

Ekholm Enterprises Inc.

Package Delivery Drivers Job at Ekholm Enterprises Inc.

 ...Job Description Hiring Delivery Drivers! No experience necessary! Benefits provided! We are looking for people who have a strong work ethic and are motivated to be part of a team, to deliver and pick-up packages from local businesses and residences. We equip each... 

Express Freight

Class A WHO WANTS TO DRIVE A TRUCK. CLASS A NEEDED Job Job at Express Freight

 ...coast. You will be home weekly to our Aurora location. Trucks are all 2015 and up . They are equipped with refrigerators, tv, xm radio, prepass, comfortable seats, microwave, tinted windows.Starting pay is $.45 cpm, and is more depending on experience and length at... 

Department of State Hospitals

DSH- NAPA ( APPIC) CLINICAL PSYCHOLOGY INTERN Job at Department of State Hospitals

 ...Job Description and Duties DSH-Napa Psychology Department has openings for fourfull-time, limited-term Clinical Psychology Interns.For more information about these positions, please contact Dr. Kaitlyn Eichenberger at (***) ***-****. RECRUITMENT CRITERIA MUST...