Data Engineer Senior Associate

Chicago, United States

Apply now Apply later

Your Journey at Crowe Starts Here:

At Crowe, you can build a meaningful and rewarding career. With real flexibility to balance work with life moments, you’re trusted to deliver results and make an impact. We embrace you for who you are, care for your well-being, and nurture your career. Everyone has equitable access to opportunities for career growth and leadership. Over our 80-year history, delivering excellent service through innovation has been a core part of our DNA across our audit, tax, and consulting groups. That’s why we continuously invest in innovative ideas, such as AI-enabled insights and technology-powered solutions, to enhance our services. Join us at Crowe and embark on a career where you can help shape the future of our industry.

Job Description:

The Data Engineer Senior Developer will provide critical infrastructure for analytical support and solution development for the broader Enterprise using market leading tools and methodologies. In this role, you will harness your expertise in dimensional modeling and advanced data engineering skills to create and deliver robust BI solutions and data products, catering to the needs of our internal stakeholders. The ideal candidate must have deep expertise in data modeling, infrastructure development, and will be responsible for designing, developing, and maintaining the Enterprise Analytics Platform to support data-driven decision-making across the organization. Success in this role requires a strong interest in analysis, best practice knowledge, critical thinking, problem-solving, as well as excellent interpersonal, communication, listening and presentation skills. The Data team strives for an unparalleled client experience and will look to you to promote our success and image firmwide.

Responsibilities
  • Design, develop and implement advanced, scalable, and highly performant data pipelines using Azure Data Factory, SQL, and Python to support analytics and reporting.
  • Integrate data from various sources, including SQL databases, Excel, cloud services, and other BI tools to develop and optimize data models (OLTP, OLAP) and ETL workflows to support reporting.
  • Collaborate with other developers, senior leadership, and business SMEs to discover platform solution requirements, while performing data discovery and independently executing complex data analysis across multiple platforms (e.g., SQL, Fabric, Power BI, and Excel).
  • Work with Microsoft Fabric to build and manage modern data infrastructure platform in a medallion architecture (Bronze, Silver, Gold), leveraging PySpark and other Notebook-based approaches.
  • Demonstrate platform capabilities and promote application of tools as appropriate to address business requirements.
  • Collaborate with peers on best practices for security, governance, and performance optimization.
  • Understand and apply intermediate to advance Azure DevOps methodologies to drive an exemplary customer experience; apply elementary project management techniques to ensure communicable progress.
  • Document processes, data flows, and architecture to ensure system transparency and maintainability.
  • Effectively communicate across the organization in a manner easily understood by individuals with diverse technical and business backgrounds.

Requirements
  • Intermediate or advanced proficiency and knowledge of databases (on-prem or cloud), querying data using SQL, Python, Power Query, or other comparable languages.
  • Working Knowledge of Azure Data Services (e.g., Azure SQL Database, Azure Data Factory)
  • Substantial experience with data modeling, ETL processes, as well as advanced understanding of dimensional modelling.
  • Proficient in integrating data from various sources, including cloud-based platforms via API. Strong understanding of cloud ecosystems (Azure, AWS, GCP).
  • Experience with Postman, SSAS Tabular, DAX Studio, ALM Toolkit, and/or Tabular Editor (2 or 3) a plus.
  • Familiarity with Power BI semantic modelling, machine learning and advanced analytics a plus
  • Expert skills in Microsoft PowerPoint, Excel, and Word.
  • Ability to work independently and manage multiple priorities in a fast-paced environment.
  • A good understanding of the agile development cycle and familiarity with Smartsheet or Azure DevOps preferred.
  • Stay updated and up to speed with regards to new features, techniques, findings, and best practices emergent for core platforms.
  • As required, work after-hours and during maintenance periods.
  • Limited travel required to perform job duties (< 5%).

Qualifications
  • Bachelor’s degree in computer science, Data Analytics, Data/Information Science, Information Systems, Mathematics (or other related fields).
  • 3+ years of experience with SQL and data warehousing concepts.
  • 3+ years of experience in supporting Business Intelligence, data analysis, and reporting.
  • 2+ years of experience with Python (or other programming languages).
  • 2+ years of experience with Microsoft Power BI, including DAX, Power Query, and M language.
  • 2+ years of experience managing projects from inception to execution.
  • 1+ years of experience working with Delta Lake or Apache Spark (Fabric or Databricks).
  • Hands on experience or certification with Microsoft Fabric preferred.

Key Position Interactions
  • Head of Data
  • Senior Data Architects
  • Customer Success, Data Products, and Data Governance Program Leads/teams
  • Data owners, data stewards, data product owners, project managers, and internal BI clients
  • Information Security

#Remote

We expect the candidate to uphold Crowe’s values of Care, Trust, Courage, and Stewardship. These values define who we are. We expect all of our people to act ethically and with integrity at all times.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Crowe, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $65,800.00 - $135,400.00 per year.

Our Benefits:
Your exceptional people experience starts here. At Crowe, we know that great people are what makes a great firm. We care about our people and offer employees a comprehensive total rewards package. Learn more about what working at Crowe can mean for you!

How You Can Grow:
We will nurture your talent in an inclusive culture that values diversity. You will have the chance to meet on a consistent basis with your Career Coach that will guide you in your career goals and aspirations. Learn more about where talent can prosper!

More about Crowe:
Crowe (www.crowe.com) is one of the largest public accounting, consulting and technology firms in the United States. Crowe uses its deep industry expertise to provide audit services to public and private entities while also helping clients reach their goals with tax, advisory, risk and performance services. Crowe is recognized by many organizations as one of the country's best places to work. Crowe serves clients worldwide as an independent member of Crowe Global, one of the largest global accounting networks in the world. The network consists of more than 200 independent accounting and advisory services firms in more than 130 countries around the world.

Crowe LLP provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

Crowe LLP does not accept unsolicited candidates, referrals or resumes from any staffing agency, recruiting service, sourcing entity or any other third-party paid service at any time. Any referrals, resumes or candidates submitted to Crowe, or any employee or owner of Crowe without a pre-existing agreement signed by both parties covering the submission will be considered the property of Crowe, and free of charge.

Apply now Apply later
Job stats:  0  0  0
Category: Engineering Jobs

Tags: Agile APIs Architecture AWS Azure Business Intelligence Computer Science Consulting CX Data analysis Data Analytics Databricks Data governance Data pipelines Data Warehousing DevOps Engineering ETL Excel GCP Machine Learning Mathematics OLAP Pipelines Power BI PySpark Python Security Spark SQL

Perks/benefits: Career development

Region: North America
Country: United States

More jobs like this