Data Analyst
rockITdata
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
ETLSQL
About the role
- Collaborate with the Product Owner, stakeholders, and end users to gather and analyze data requirements
- Work with data engineers to understand the technical landscape, data sources, and data flows within the organization
- Translate business requirements into detailed technical specifications, including data models, data dictionaries, and ETL (Extract, Transform, Load) processes
- Participate in the design and implementation of data pipelines, data warehouses, and data marts
- Assist in the development of data quality and validation procedures
- Support the testing and validation of data solutions, ensuring data accuracy and integrity
- Conduct in-depth analysis of complex datasets to identify trends, patterns, insights, and improvement opportunities and potential solutions
- Develop and maintain comprehensive data dictionaries and mappings
- Design conceptual, logical, and physical data models to support business needs
- Create and maintain Entity-Relationship Diagrams (ERDs) to visualize data relationships
- Establish and enforce data naming conventions to ensure consistency and clarity
- Utilize advanced SQL skills to query, manipulate, and analyze large datasets
- Develop and optimize SQL queries for performance and efficiency
- Create and maintain data validation scripts to ensure data quality
- Participate in agile ceremonies, such as Sprint planning, backlog refinement, and Sprint reviews
- Work with our clients and data engineering team to create features and user stories that align with business goals and product vision
- Maintain regular communication with clients to provide updates, gather feedback and address their expectations
Requirements
- Bachelor's degree in Computer Science, Information Systems, or a related field
- 3+ years of proven experience as a Data Analyst, with a strong emphasis on data modelling and SQL
- Strong understanding of data engineering principles, data warehousing, data modeling, and ETL processes
- Proficiency in SQL and data analysis tools
- Experience working with Agile methodologies
- Excellent analytical, problem-solving, and communication skills
- Ability to work independently and as part of a team
Benefits
- Health insurance
- 401(k) matching
- Flexible work arrangements
- Paid time off
- Professional development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata modelingETLdata analysisdata warehousingdata pipelinesdata qualitydata validationdata dictionariesEntity-Relationship Diagrams
Soft skills
analytical skillsproblem-solvingcommunicationcollaborationindependenceteamwork