Job Description
Job DescriptionBusiness Analyst / Tester – Application Modernization
Location: EST/CST | Company: CEI
About CEI
CEI’s Solutions group delivers custom application development across web, mobile, integration, and cloud. We partner with Microsoft, GitHub, and AWS and support clients with both strategy and managed services.
Position Overview
We are seeking a detail-oriented Data Business Analyst to transform raw data into actionable business insights. This role requires strong SQL capabilities combined with business acumen to analyze trends, create reports, and support strategic decision-making across the organization.
Key Responsibilities
Data Analysis & Reporting
- Data modeling focus
- Integration of data streams
- Write complex SQL queries to extract, manipulate, and analyze data from multiple databases
- Develop and maintain dashboards, reports, and visualizations using BI tools (Tableau, Power BI, or similar)
- Perform data quality assessments and identify inconsistencies or anomalies
- Conduct ad-hoc analysis to support business initiatives and answer stakeholder questions
- Create automated reporting solutions to streamline recurring data requests
Business Intelligence
- Translate business requirements into technical specifications and analytical frameworks
- Identify trends, patterns, and insights from large datasets to drive business strategy
- Build financial models, forecasts, and predictive analyses to support planning
- Develop KPIs and metrics to measure business performance
- Present findings and recommendations to leadership and cross-functional teams
Stakeholder Collaboration
- Partner with business units to understand objectives, pain points, and data needs
- Facilitate requirements gathering sessions and document business processes
- Act as liaison between technical teams and business stakeholders
- Provide data expertise and guidance for project initiatives
- Train end-users on self-service reporting tools and best practices
Data Management
- Document data sources, definitions, and business logic for reports and analyses
- Participate in data governance initiatives and ensure compliance with data policies
- Support data integration projects and validate data accuracy
- Recommend improvements to data collection and storage processes
Required Qualifications
Experience:
- 3-5 years of experience as a Business Analyst, Data Analyst, or similar role
- Proven track record of using data to solve business problems
Technical Skills:
- Advanced SQL: Strong proficiency writing complex queries including joins, subqueries, CTEs, window functions, and query optimization
- Experience with relational databases (SQL Server, Oracle, MySQL, PostgreSQL)
- Proficiency in at least one BI/visualization tool (Tableau, Power BI, Looker, QlikView)
- Strong Microsoft Excel skills (pivot tables, VLOOKUP, formulas, macros)
- Experience with data modeling concepts and dimensional design
Business Skills:
- Excellent analytical and problem-solving abilities
- Strong understanding of business processes and financial metrics
- Ability to translate technical concepts for non-technical audiences
- Detail-oriented with commitment to data accuracy
- Project management and organizational skills
Education:
- Bachelor's degree in Business Administration, Economics, Statistics, Computer Science, or related field
Preferred Qualifications
- Experience with Python or R for statistical analysis
- Knowledge of ETL processes and data warehousing concepts
- Familiarity with cloud platforms (AWS, Azure, Google Cloud)
- Experience in [specific industry: healthcare, finance, retail, etc.]
- Certification in SQL, Tableau, or Power BI
- Master's degree in Analytics, Data Science, or MBA
- Agile/Scrum methodology experience
Core Competencies
- Analytical Thinking: Ability to break down complex problems and derive insights
- Communication: Clear presentation of findings to diverse audiences
- Curiosity: Natural drive to explore data and ask "why"
- Collaboration: Effective team player across departments
- Adaptability: Comfortable working in fast-paced, changing environments
- Business Acumen: Understanding of how data impacts business outcomes
#INDCEI
#ZR