Business Intelligence Data Engineer

Posted 9 Days Ago
Chicago, IL
Mid level
Fintech • Payments • Financial Services
The Role
The Business Intelligence Data Engineer will design and manage data infrastructure, develop ETL processes, and create visualizations to enable data-driven decision-making. They will collaborate with stakeholders to deliver insights and ensure data integrity while monitoring performance and compliance with governance policies.
Summary Generated by Built In

Who we are:

Strongpoint Partners is an Inc. 5000 recognized fast-growing, tech-enabled retirement services platform serving small- to mid-sized businesses with integrated retirement third party administration, recordkeeping, payroll, and HR solutions. Strongpoint’s suite of services prioritizes accuracy, compliance, and reduction of regulatory risk for its clients, delivered by local client success teams that understand the nuances of the markets they serve. With a coast-to-coast network of leading firms including HowardSimon, Jocelyn Pension Consulting, Retirement Strategies Group, Retirement Planners and Administrators, Pension Financial Services, Pollard & Associates, Carlson Quinn, SI GROUP, Retirement Planning Consulting Group, Karel-Gordon & Associates, Cash Balance Actuaries, and Pension Consultants Inc, Strongpoint Partners combines a relentless passion for service and innovation with the experience and expertise required to make retirement work for everyone. 

We are seeking a highly skilled and motivated Business Intelligence Data Engineer to join our Data & Analytics team. The ideal candidate will be responsible for designing, developing, and managing our data infrastructure, as well as extracting, transforming, and loading (ETL) data from various sources. You will play a critical role in enabling our business stakeholders to make data-driven decisions by providing accessible, accurate, and timely business intelligence visualizations. 

Their duties include guiding, building, and executing upon our long-term data pipelining and business intelligence roadmap in addition to being the primary oversight for execution of related activities. The candidate will interface and work closely with data stakeholders, the executive team, as well as leaders from across the organization. 

**Strongpoint’s headquarters is in Chicago – our preference is for this role to be hybrid in the Chicago area.** 

What you'll do: 

Data Infrastructure Management: 

  • Design, construct, install, test, and maintain highly scalable data warehousing systems. 
  • Ensure systems meet business requirements and industry practices for data integrity, performance, and reliability. 
  • Monitor data performance and modify infrastructure as needed. 
  • Implement data governance policies and comply with data protection regulations. 

Extract/Transform/Load (ETL) Duties: 

  • Develop and maintain scalable and robust ETL pipelines to support data collection, integration, and transformation needs. 
  • Collaborate with relevant business stakeholders to assist in data cleaning, data exploration, and delivering timely data into relevant destination data warehouse(s). 
  • Optimize data retrieval, develop dashboards, reports, and visualizations to facilitate business decisions. 

Business Intelligence & Visualization: 

  • Transform raw data into insightful business intelligence visualizations and interactive dashboards using BI tools like Power BI, AWS Quicksight, or similar. 
  • Work closely with stakeholders to understand their data analysis needs and deliver comprehensive data insights to aid strategic decision-making. 
  • Regularly review and improve existing BI solutions for performance and scalability. 

Collaboration & Communication: 

  • Collaborate with IT, security, and business teams to understand data governance requirements and implement systems accordingly. 
  • Communicate complex data concepts and insights in a clear and concise manner to stakeholders at all levels of the organization. 
  • Provide training and support to business users to effectively utilize BI tools and dashboards. 

Who you are:  

  • Bachelor's or equivalent degree in Computer Science, Engineering, Information Technology, or a related field. 
  • 3-5+ years experience in prior data engineering roles with a focus on ETL processes and Business Intelligence. 
  • Strong knowledge of SQL and experience with relational databases 
  • Extensive experience with data pipeline and workflow management tools. 
  • Proficiency in one or more programming languages (e.g., Python, Java, Scala). 
  • Experience with Enterprise Data Warehouse & BI tools, such as Snowflake, Power BI, AWS Quicksight, or similar. 
  • Excellent problem-solving skills and attention to detail. 
  • Strong communication and collaboration skills, with the ability to work effectively in a team environment. 
  • Outstanding written and verbal communication skills 
  • Creative thinking with a data-driven approach  

 

Our Value-Driven Employee Experience:

  • Flexible Workplace
  • Competitive PTO
  • Inclusive Environment
  • Development Opportunities
  • Comprehensive Benefits
  • Workplace Perks




Top Skills

Aws Quicksight
Java
Power BI
Python
Scala
Snowflake
SQL
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, Illnois
116 Employees
On-site Workplace

What We Do

Strongpoint Partners is a fast-growing, tech-enabled financial services platform that provides third-party retirement administration (“TPA”), recordkeeping, and integrated payroll and HR technology solutions for small-and-medium businesses. Strongpoint’s suite of services prioritizes accuracy, compliance, and reduction of regulatory risk, all delivered by local customer success teams that understand the nuances of the markets they serve. Made up of a coast-to-coast network of leading retirement strategy and administration firms including HowardSimon, Jocelyn Pension Consulting, Retirement Strategies Group (“RSG”), and Retirement Planners and Administrators (“RPA”), Strongpoint Partners combines a relentless passion for service and innovation with the experience and expertise required to make retirement work for everyone. For more information, please visit: www.strongpointpartners.com

Similar Jobs

CNA Logo CNA

Sr. Informatica Data Engineer (Power BI / ETL)

Cloud • Insurance • Professional Services • Analytics • Cybersecurity
Hybrid
Chicago, IL, USA
7000 Employees
72K-141K Annually

PwC Logo PwC

Data Engineer - Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Remote
69 Locations
370000 Employees
84K-202K Annually
Remote
18 Locations
4900 Employees
120K-160K Annually

Belvedere Trading Logo Belvedere Trading

Senior Data Engineer

Fintech • Information Technology • Other • Software • Financial Services
Easy Apply
Hybrid
Chicago, IL, USA
265 Employees

Similar Companies Hiring

Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account