BI Analyst
The BI Analyst at Confidential Client is responsible for analyzing business data, developing interactive dashboards and reports, and providing actionable insights to support data-driven decision-making. This role involves collaborating with stakeholders, ensuring data quality, and utilizing BI tools such as Power BI and Tableau to deliver meaningful business intelligence. The position is entry-level, ideal for candidates with up to 2 years of experience or relevant academic projects.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, IT.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
Position Overview
Confidential Client (via Careertakes) is hiring a Business Intelligence (BI) Analyst in New Haven, CT. This full-time, entry-level role is ideal for candidates with strong analytical skills, SQL knowledge, and experience or coursework with Power BI, Tableau, or similar BI tools. The BI Analyst will build reports and dashboards, validate data quality, and present insights that inform business decisions.
- Estimated annual pay: $68,269 (estimated)
What You’ll Do
- Collect, analyze, and interpret data from multiple business sources to answer operational questions.
- Design, build, and maintain interactive dashboards and reports using Power BI, Tableau, or similar tools.
- Write and optimize SQL queries to extract, transform, and analyze data.
- Create and maintain KPIs, metrics, and operational performance reports.
- Validate data accuracy and perform data quality checks and reconciliations.
- Assist with data modeling, transformation, and report automation.
- Collaborate with Data Analysts, Data Engineers, and business stakeholders to define reporting requirements.
- Document reporting logic, data sources, and business requirements.
- Present findings and insights to technical and non-technical audiences.
Required Skills & Experience
- Strong analytical and problem-solving skills.
- Proficiency in SQL.
- Experience or academic knowledge of Power BI, Tableau, or another BI tool.
- Strong Microsoft Excel skills.
- Basic understanding of data modeling and relational databases.
- Knowledge of KPIs, dashboards, and data visualization best practices.
- Good written and verbal communication; comfortable working with stakeholders.
- Ability to analyze moderately large datasets and identify meaningful insights.
Preferred (Nice-to-Have)
- Knowledge of Power BI DAX and Power Query.
- Familiarity with Python or R for data analysis.
- Basic understanding of ETL/ELT processes.
- Experience with cloud analytics platforms (AWS, Azure, Google Cloud).
- Familiarity with SQL Server, MySQL, PostgreSQL, Snowflake, or Redshift.
- Knowledge of Agile/Scrum and tools such as JIRA and Confluence.
- Internship, academic projects, or prior experience in Data Analytics or Business Intelligence.
Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, or related field (or equivalent coursework/projects).
- 0–2 years of relevant experience. Entry-level candidates with internships, certifications, or academic projects are encouraged to apply.
Working Environment & Location
- Onsite in New Haven, CT. Occasional collaboration with cross-functional teams is expected.
- Employment will be with Confidential Client; Careertakes supports the recruiting process as a third-party platform.
Additional Details
- This role is posted as FULL_TIME.
- Applicants should be authorized to work in the U.S.
- Careertakes and our client follow applicable federal, state, and local hiring laws for Connecticut.
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range