Data Platform Developer

Not Interested
Bookmark
Report This Job

profile Job Location:

Chicago, IL - USA

profile Monthly Salary: Not Disclosed
Posted on: Yesterday
Vacancies: 1 Vacancy

Job Summary

ABOUT US

At HUB International we are a team of entrepreneurs. We believe in protecting and supporting the aspirations of individuals families and businesses. We help our clients evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees to learn grow and make a difference. Our structure enables our teams to maintain their own unique regional culture while leveraging support and resources from our corporate centers of excellence.

HUB is a global insurance and employee benefits broker providing a boundaryless array of business insurance employee benefits risk services personal insurance retirement and private wealth management products and services. With over $5 billion in revenue and almost 20000 employees in 600 offices throughout North America HUB has grown substantially in part due to our industry leading success in mergers and acquisitions.

Position Summary

We are seeking a skilled Data Platform Developer to design develop and maintain our database infrastructure and reporting capabilities. This role is critical to supporting data-driven decision-making across the organization with a primary focus on Snowflake cloud data platform management and optimization.

Key Responsibilities

Database Development & Management

  • Design build and maintain SQL databases data models and ETL processes
  • Write and optimize complex SQL queries stored procedures and functions
  • Ensure data integrity security and compliance with organizational standards

Snowflake Platform Administration

  • Develop and manage data pipelines within Snowflake
  • Optimize Snowflake performance including query tuning and resource management
  • Implement and maintain role-based access controls and data governance policies

Reporting & Analytics Support

  • Create and maintain views tables and data structures to support reporting tools and dashboards
  • Partner with business stakeholders to translate requirements into technical solutions
  • Troubleshoot and resolve data discrepancies and performance issues

Collaboration & Documentation

  • Work cross-functionally with Operations Analytics and IT teams
  • Document data architecture workflows and standard operating procedures
  • Contribute to continuous improvement of data infrastructure and processes

Documentation & Knowledge Management Create and maintain comprehensive technical documentation including:

  • Data architecture diagrams (ERDs data flow diagrams system integration maps)
  • Data pipeline documentation (Coalesce/dbt DAGs transformation logic dependencies)
  • API documentation (endpoint specifications authentication flows payload schemas)
  • Stored procedure and function libraries (purpose parameters usage examples)
  • Data dictionaries - Create and maintain comprehensive documentation including data dictionaries ETL workflows SOPs runbooks governance policies process diagrams and training materials

Required Qualifications

  • 3 years of hands-on experience in SQL development and database management
  • Proficiency with Snowflake including data warehousing query optimization and administration
  • BigQuery the ability to build optimization of data tables leveraging native connectors for Power BI and data integration
  • Strong experience with relational database concepts and data modeling
  • Familiarity with ETL tools (Dataflow Pub/Sub) data integration and orchestration processes
  • Ability to write efficient scalable SQL code

Preferred Qualifications

  • Experience with cloud platforms (AWS Azure or GCP) and serverless architecture (Lambda functions event-driven processing)
  • Python expertise for data engineering including stored procedures Lambda functions and API integrations
  • Experience with BI/reporting tools (Tableau Power BI Looker) and data pipeline orchestration (dbt Airflow)
  • Experience building Snowflake stored procedures (SQL/Python) UDFs and data automation workflows
  • Knowledge of API integrations REST APIs and cloud data pipelines (S3 PowerAutomate)
  • Background in insurance benefits or financial services with familiarity in benefits administration and carrier data

Competency

  • Strong analytical and problem-solving skills
  • Ability to communicate technical concepts to non-technical stakeholders
  • Detail-oriented with a focus on data accuracy and quality
  • Self-directed with the ability to manage multiple priorities

JOIN OUR TEAM

Do you believe in the power of innovation collaboration and transformation Do you thrive in a supportive and client focused work environment Are you looking for an opportunity to help build and drive change in a rapidly growing and evolving organization When you join HUB International you will be part of a community of learners and doers focused on our Core Values: entrepreneurship teamwork integrity accountability and service.

Disclosure required under applicable law in California Colorado Illinois Maryland Minnesota New York New Jersey and Washington states: The expected salary range for this position is $90K to 115K and will be impacted by factors such as the successful candidates skills experience and working location as well as the specific positions business line scope and level. If you believe that your qualifications and experience surpass the minimum requirements for this role we encourage you to submit your application. By doing so we will be able to keep your application on file for consideration for potential future positions within our organization. HUB International is proud to offer comprehensive benefit and total compensation packages which could include health/dental/vision/life/disability insurance FSA HSA and 401(k) accounts paid-time-off benefits such as vacation sick and personal days and eligible bonuses equity and commissions for some positions.

Department Information Technology

Required Experience: 2-5 years of relevant experience

Required Travel: Negligible

Required Education: Bachelors degree (4-year degree)

HUB International Limited is an equal opportunity employer that does not discriminate on the basis of race/ethnicity national origin religion age color sex sexual orientation gender identity disability or veterans status or any other characteristic protected by local state or federal laws rules or regulations.

E-Verify Program

We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process please contact the recruiting team. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.


Required Experience:

IC

ABOUT USAt HUB International we are a team of entrepreneurs. We believe in protecting and supporting the aspirations of individuals families and businesses. We help our clients evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees to learn grow an...
View more view more

Key Skills

  • CCTV
  • Computer Science
  • Corporate Marketing
  • E Learning
  • Arabic English Translation

About Company

Company Logo

HUB International is a leading North American insurance brokerage that provides employee benefits, business, and personal insurance products and services.

View Profile View Profile