Data Engineer

3 months ago

Chicago, United States RSM Solutions, Inc Full time

Thank you for stopping by to take a look at the Data Engineer with a focus on SSRS and PowerBI role I have posted here on LinkedIN, I appreciate it.


If you have read my JD's in the past, you will know that I like to add humor to these things. So, if you see something in here that gives you a chuckle, that was the intent. If you are new to my JD's, welcome to the party.


As with just about everything I work on, social fit is going to be almost as important as the technical fit. So, you might ask...what are some of these social fit pieces of this role:

  1. This is a role where you will be working with end users and that need to communicate in the same mindset of that great Steven Covey habit of 'first seek to understand...then to be understood' will be needed for success here. By the way, if you haven't read 7 Habits of Highly Effective People, oh man...you are really missing out. It just might change how you communicate with everyone about everything.
  2. Have you ever been in an environment with a lot of backstabbing passive aggressive types? That kinda stinks, doesn't it? Well, you wont have to deal with that here. The individuals you will be working with actually have a vested interest in your success and will cheer you on as opposed to drag you down.
  3. You will be working on things that actually have consequences to the overall business. This is a 100 year old law firm that is really using IT to drive decisions (I know, who would have thunk that). So, that ability to collaborate with others, drive into the details of what is really being asked, and then execute on that will be a real key to success here.


This role is permanent and fully benefited


This role is being done in a hybrid manner with 3 days onsite (311 West Monroe in Downtown Chicago) and 2 days remote.


We are only able to work with candidates that already reside in the Chicago area for this role.


I can only work with US Citizens or Green Card Holders for this role.


Here is what we are looking for: The official Title of this role is 'Financial Applications Data Engineer'. However, under the covers, it is really a Data role focused on SSRS and PowerBI. If you have some really solid SSRS and PowerBI skills along with some SSIS skills, that is spot on with what we are seeking in this role. You will be responsible for the data analysis, dashboarding, and reporting for the finance & accounting departments. The ETL skill (SSIS) will be needed so that your reporting and PBI dashboards will actually reflect the right data as opposed to reporting off of stuff that doesn't make a ton of sense. You will be working within an existing team of data engineers that focus on the data layer as well as other aspects of the BI stack.


I won't bore you to tears with a ton of essential duties...instead, I will share the highlights:

  • Rapidly builds and maintains an understanding of the firm’s “data landscape” – the key systems and databases used across the firm, how they are used, their data, data models and data integrations, with a specific focus on Finance & Accounting data.
  • Work with fun stuff like data cleansing efforts, creation of reliable data pipelines and ETL processes, join & relate data from disparate systems.
  • Prepare data for modeling, reporting, visualization and analysis (you will be working with the backend data team for the preparation part...we really want to to want to participate, however).
  • Generate a variety of reporting outputs, leveraging Microsoft Power BI and other tools.
  • Works with our Enterprise Data Architect in the design and implementation of new data models that may pertain to Finance & Accounting.
  • Design and build sSQL queries, views, functions and stored procedures.
  • Develop and implements various Finance & Accounting and related dashboards.
  • Provide technical assistance and guidance to others, both within and outside of IT, helping them to locate and access the data they need.
  • Works with our Enterprise Data Architect and Data Engineers in other functions to build a strong community of expertise that supports the development and delivery of the firm’s data strategy
  • Design, builds and tests data structures and reporting process/systems
  • Participates in rotational 24 x 7 application support ensuring that the application portfolio uptime is maintained according to defined SLA’s


Here is what we are seeking:

  • At least 4 years of PowerBI and SSRS experience. I am more interested in breath and depth of that PBI & SSRS experience. So, we are looking for that ability to 'make sense of data'...not just build reports and dashboards.
  • Experience working with organizational data warehouses, including the creation and management of the data residing within them. You will be focusing on the presentation layer (SSRS and PBI), but that experience with understanding what the data and ETL layer is telling you will be need in this role. So, yep, we are looking for at least some SSIS experience.
  • Experience with both on prem Sql and Azure Sql.
  • Data engineering certifications (e.g. Azure Certified Data Engineer) are a plus.

  • Data Theorem Security Specialist

    1 week ago

    Chicago, Illinois, United States Data Theorem Full time

    Job Title: Systems EngineerWe are seeking a highly skilled Systems Engineer to join our team at Data Theorem. As a Systems Engineer, you will work closely with customers and prospects to understand their security needs and provide solutions that meet their requirements.Key Responsibilities:Develop and deliver product demonstrations and sales presentations to...

  • Senior Software Engineer

    4 days ago

    Chicago, Illinois, United States Spline Data Full time

    Spline Data is a pioneering company in the field of modern quantitative market data feeds and visualizations for fixed income trading desks, portfolio managers, and issuers. We strive for excellence in every aspect of our business, ensuring that the data we create is of the highest quality, detail, and robustness.We believe that innovation often lies in the...

  • Data Engineer

    2 weeks ago

    Chicago, Illinois, United States WHIZTEK CORP Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Whiztek Corp. As a Data Engineer, you will play a critical role in designing, building, and maintaining large-scale data pipelines and architectures.Key Responsibilities:Design and implement data pipelines using AWS services such as Redshift, S3, and AthenaDevelop and...

  • Data Engineer

    1 week ago

    Chicago, Illinois, United States IFF Full time

    Job Title: Data EngineerIFF is seeking a skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining data integration and synchronization processes across our core business applications and data warehouses.Key Responsibilities:Collaborate with the Data Architect and Chief Data Officer to...

  • Data Engineer

    1 day ago

    Chicago, United States Insight Global Full time

    This specialty insurance company is seeking a highly skilled and experienced Lead Data Engineer to join our dynamic team. This individual will be instrumental in administering, optimizing, and innovating our data engineering practices and infrastructure, particularly in an Azure environment. The Lead will ensure that our data engineering practices are...

  • Software Engineer

    2 months ago

    Chicago, United States Spline Data Full time

    Spline Data is a focused on building modern quantitative market data feeds and visualizations for fixed income trading desks, portfolio managers, issuers, and beyond. We regard the data we create as if we were trading it ourselves, meaning detail, demonstrability, and robustness are key in every facet of our business. Changing a market isn't always about...

  • Data Engineer

    1 week ago

    Chicago, Illinois, United States SpiderRock Holdings LLC Full time

    Job OpportunityWe are seeking a highly skilled Data Engineer to join our team at SpiderRock Holdings LLC. As a Data Engineer, you will play a critical role in developing and maintaining our data infrastructure, ensuring the accuracy and reliability of our data products.Key ResponsibilitiesDesign, develop, and implement data pipelines and architectures to...

  • Data Engineer

    3 weeks ago

    Chicago, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are offering a long-term contract opportunity for a Data Engineer. This role is crucial in the development and optimization of data systems through the design and construction of ETL pipelines, data models, queries, and scripts. The Data Engineer will work closely with business domain leads, data scientists, product owners,...

  • Systems Engineer

    2 months ago

    Chicago, United States Data Theorem Full time

    Job DescriptionJob DescriptionData Theorem is an exciting company focused on creating a more secure world for data. Rooted in a strong engineer first culture, every employee has an impact on product and direction. We are searching for exceptional talent pursuing an opportunity to grow and take ownership of the projects that resonate most with them.Our...

  • Data Engineer

    1 week ago

    Chicago, Illinois, United States Publicis Media Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Publicis Media. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data systems that support our business operations.Key Responsibilities:Analyze business requirements and collaborate with product owners to develop scalable...

  • Data Engineer

    2 months ago

    Chicago, United States McDonald's Full time

    McDonald's evolving Accelerating the Arches growth strategy puts our customers and people first and demonstrates our competitive advantages to strengthen our brand. We are recognized on lists like Fortune’s Most Admired Companies and Fast Company’s Most Innovative Companies.Doubling Down on the 4Ds (Delivery, Digital, Drive Thru, and Development)Our...

  • Data Engineer

    2 months ago

    Chicago, United States McDonald's Full time

    McDonald's evolving Accelerating the Arches growth strategy puts our customers and people first and demonstrates our competitive advantages to strengthen our brand. We are recognized on lists like Fortune’s Most Admired Companies and Fast Company’s Most Innovative Companies.Doubling Down on the 4Ds (Delivery, Digital, Drive Thru, and Development)Our...

  • Data Engineer

    5 days ago

    chicago, United States Acunor Full time

    Job title: Data EngineerLocation: Chicago, IL (3 days Onsite)Duration: Full Time We are looking for a go getter person who can define: Analytic strategies to meet the demands of business requirementsTechnical requirements of the analytic solutionsData requirements of the analytic solution processesRole Overview:The person will be part of the Data Analytics &...

  • Data Engineer

    1 week ago

    Chicago, United States Acunor Full time

    Job title: Data EngineerLocation: Chicago, IL (3 days Onsite)Duration: Full Time We are looking for a go getter person who can define: Analytic strategies to meet the demands of business requirementsTechnical requirements of the analytic solutionsData requirements of the analytic solution processesRole Overview:The person will be part of the Data Analytics &...

  • Data Engineer

    7 days ago

    Chicago, United States Acunor Full time

    Job title: Data EngineerLocation: Chicago, IL (3 days Onsite)Duration: Full Time We are looking for a go getter person who can define: Analytic strategies to meet the demands of business requirementsTechnical requirements of the analytic solutionsData requirements of the analytic solution processesRole Overview:The person will be part of the Data Analytics &...

  • Data Engineer

    4 weeks ago

    Chicago, United States Selby Jennings Full time

    We are seeking a Data Engineer to join the commodities team at a leading trading firm, where you'll be responsible for building and maintaining data pipelines for the ingestion, management, and analysis of datasets used by traders. Key Responsibilities:Develop and maintain reliable ETL pipelines using Python.Collaborate within a small, experienced...

  • Data Engineer

    2 weeks ago

    chicago, United States Selby Jennings Full time

    We are seeking a Data Engineer to join the commodities team at a leading trading firm, where you'll be responsible for building and maintaining data pipelines for the ingestion, management, and analysis of datasets used by traders. Key Responsibilities:Develop and maintain reliable ETL pipelines using Python.Collaborate within a small, experienced...

  • Data Engineer

    2 weeks ago

    Chicago, United States WHIZTEK CORP Full time

    Job Title: Data Engineer Location: Chicago IL Duration: long term Top 5 Skill sets DevOps AWS Cloud Terraform Python 5 CI/CD pipelines Nice to have skills or certifications: Blue-Green deployments Kubernetes Ansible Playbooks JOB OVERVIEW AND RESPONSIBILITIES: In this role you will partner with various teams to define and execute data...

  • Data Engineer

    2 weeks ago

    Chicago, Illinois, United States Publicis Media Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Publicis Media. As a Data Engineer, you will play a critical role in the development, implementation, and ongoing support of our data-driven software platform.Key Responsibilities:Analyze business requirements and collaborate with product owners to build scalable...

  • Senior Software Engineer

    2 months ago

    Chicago, United States Spline Data Full time

    Spline Data is a focused on building modern quantitative market data feeds and visualizations for fixed income trading desks, portfolio managers, issuers, and beyond. We regard the data we create as if we were trading it ourselves, meaning detail, demonstrability, and robustness are key in every facet of our business. Changing a market isn't always about...