Data Analyst

Company Description

BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the industry average.

BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and best-in-class performance.

BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for its customers.

BETSOL offices are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India.

We take pride in being an employee-centric organization, offering comprehensive health insurance, competitive salaries, 401K, volunteer programs, and scholarship opportunities. Office amenities include a fitness center, cafe, and recreational facilities.

Learn more at betsol.com

Job Description

Position Overview

We are seeking a skilled Data Analyst to work closely with our Business, Client Stakeholders, Application, Data Services and BI teams to deliver high-quality data solutions and business intelligence. This role requires a detail-oriented professional who can analyze data requirements, perform data profiling and mapping, support ETL development, create insightful reports and dashboards, and ensure data quality throughout the data lifecycle. You'll bridge the gap between business stakeholders and technical teams while contributing to both data integration and analytics initiatives.

Key Responsibilities

Requirements Analysis & Documentation:

• Collaborate with business stakeholders to gather and document data and reporting requirements
• Translate business needs into technical specifications for ETL and BI solutions
• Conduct requirement clarification sessions and workshops
• Document business rules, data definitions, and acceptance criteria
• Create functional specifications and user stories for development teams
• Maintain requirements traceability throughout project lifecycle

Data Analysis & Profiling:

• Perform comprehensive data profiling on source systems to understand data structures and quality
• Analyze data patterns, anomalies, and inconsistencies across multiple data sources
• Conduct gap analysis between source and target data models
• Identify data quality issues and recommend remediation strategies
• Perform statistical analysis to validate data distributions and outliers
• Document data characteristics, volumes, and refresh frequencies

Data Mapping & Design Support:

• Assist in creating detailed source-to-target data mapping documents for ETL development
• Define transformation logic and business rules for data integration
• Work with the ETL Architect to design data models and integration patterns
• Document field-level mappings including data types, formats, and transformations
• Identify and resolve data mapping conflicts and dependencies
• Support dimensional modeling and schema design activities

ETL Development Support:

• Assist the ETL Architect in developing and testing ETL processes
• Write SQL queries for data extraction, validation, and reconciliation
• Perform unit testing of ETL packages and pipelines
• Conduct data validation and reconciliation between source and target systems
• Support troubleshooting of ETL failures and data discrepancies
• Participate in code reviews and provide feedback on data logic

Data Quality & Validation:

• Design and execute data quality checks and validation rules
• Perform data reconciliation to ensure accuracy and completeness
• Identify data quality issues and coordinate resolution with source system owners
• Monitor data quality metrics and create exception reports
• Validate data after ETL loads to ensure integrity for downstream systems
• Create data quality dashboards and reports for stakeholders

Business Intelligence & Reporting:

• Collaborate with the BI Team to design reports and dashboards
• Develop reports, dashboards, and visualizations using BI tools (Power BI, Tableau, etc.)
• Create ad-hoc analyses and reports to support business decision-making
• Ensure reports meet business requirements and usability standards
• Optimize report performance and user experience
• Conduct user acceptance testing for BI deliverables
• Provide training and support to end users on reports and dashboards

Data Analysis & Insights:

• Analyze business data to identify trends, patterns, and insights
• Perform root cause analysis for data anomalies and business issues
• Create analytical reports to support strategic initiatives
• Support business stakeholders with data-driven recommendations
• Conduct comparative analysis and benchmarking studies
• Document findings and present insights to stakeholders

Collaboration & Communication:

• Work closely with ETL Architect on data integration initiatives
• Partner with BI Manager on reporting and analytics projects
• Participate in daily stand-ups and agile ceremonies
• Communicate project status, risks, and blockers to team leads
• Collaborate with developers, DBAs, and business analysts
• Provide effort estimates for analysis and reporting tasks

Required Qualifications

Experience:

• 3-5 years of experience as a Data Analyst, Business Analyst, or similar role
• Proven experience with data analysis, profiling, and mapping
• Strong background in requirements gathering and documentation
• Experience supporting ETL development and BI initiatives
• Familiarity with data warehousing concepts and methodologies

Technical Skills:

• Advanced SQL proficiency (complex queries, joins, subqueries, aggregations, window functions)
• Strong experience with SQL Server or other relational databases
• Proficiency with BI tools (Power BI, or similar)
• Experience with data profiling and analysis tools
• Knowledge of Excel for data analysis (pivot tables, VLOOKUP, formulas)
• Familiarity with SSIS and Azure Data Factory (preferred)
• Understanding of ETL concepts and data integration patterns
• Basic knowledge of data modeling and dimensional design

Analytical & Problem-Solving:

• Strong analytical and critical thinking skills
• Excellent attention to detail and data accuracy
• Ability to identify patterns, trends, and anomalies in data
• Systematic approach to troubleshooting data issues
• Logical reasoning for complex problem resolution

Core Competencies:

• Excellent written and verbal communication skills
• Strong documentation and technical writing abilities
• Ability to translate technical concepts for business audiences
• Collaborative team player with cross-functional experience
• Self-motivated with ability to manage multiple priorities
• Proactive in identifying issues and proposing solutions
• Strong organizational and time management skills
• Adaptable to changing requirements and fast-paced environments

Preferred Qualifications

• Experience with Azure cloud platform and Azure services
• Knowledge of Python or R for data analysis
• Familiarity with data visualization best practices
• Understanding of Agile/Scrum methodologies
• Experience with version control systems (Git, Azure DevOps)
• Background in specific business domains (Telecom, Contact Centre, finance, etc.)
• Experience with data governance and metadata management
• Knowledge of statistical analysis techniques

Key Success Metrics

• Accuracy and completeness of data mapping documentation
• Quality of requirements and specifications
• Data validation and reconciliation success rate
• Timeliness of analysis and reporting deliverables
• Report and dashboard user satisfaction
• Efficiency in identifying and resolving data quality issues
• Contribution to team delivery goals
• Stakeholder feedback and collaboration effectiveness

Technical Environment

• Databases: SQL Server, Azure SQL Database
• ETL Tools: SSIS, Azure Data Factory
• BI Tools: Power BI, Anaplan (or similar)
• Office Suite: Excel, Word, Visio
• Collaboration: Azure DevOps, Jira, Confluence
• Version Control: Git, Azure Repos

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, or related field
• Certification in BI tools (Microsoft Certified: Power BI Data Analyst Associate)

Additional Information

This position is expected to work in EST hours