SC&H is currently searching for an experienced Azure Data Engineer to join and help grow our Data Solutions and Analytics consulting practice located in Ellicott City, MD. SC&H Group is national management consulting and CPA firm. As a part of our team you will help empower our clients to leverage modern-data solutions to create automation, efficiency and improve decision utilizing modern data infrastructure to support a variety of business functions across the organization.

Ultimately, the ideal candidate for this role has in-depth knowledge of the full life-cycle of designing data driven solutions, which includes assisting in requirements gathering, performing source data exploration, developing sophisticated data pipelines and analytic models, and experience building the supporting visualizations for business users.

Work you'll do:

• Work in a team based environment to design and implement enterprise grade data solutions based on unique client needs, across a variety of industries
• Work with Microsoft Azure data tools and technologies including Azure Data Factory, Logic Apps, SQL Server, Synapse Analytics, Azure DevOps, and Key Vault.
• Ability to translate business requirements into technical requirements
• Actively engage with end users to understand data-intensive challenges and ensure development enables high performance movement, storage, aggregation, visualization and analytics over datasets from disparate sources
• Conduct data exploration and analysis based on business requirements and translate to technical designs
• Design and implement robust data pipelines for data transformation and movement.
• Collaborate with a Solution Architect to define client requirements and design modern data Lakehouse solutions.
• Extract, transform and load (ETL) structured and unstructured data into target systems
• Work alongside solution architects to design/create complex data models that are used to drive decision making

Qualification and Requirements:

• BS/MS in Computer Science or equivalent field
• Ability to work from SC&H office location 2x per week (Ellicott City, MD) is preferred. Remote candidates will be considered but must be able to demonstrate experience working effectively on remote teams.
• 2-3 years' experience in data engineering with a focus on data exploration, analysis, pipeline design, and data transformation (preferably in Microsoft Azure Data Services)
• Experience designing and working in advanced data modeling, data architecture, and supporting BI platforms
• Must have good communication skills, both written and verbal with experience gathering functional requirements and translating into technical design
• Must be a team player (raises issues/concerns and seeks meaningful resolution)
• Ability to write complex SQL queries and utilize common data engineering languages such as Python, Scala, etc.
• Experience working in software engineering and big data is a plus
• Experience designing/building complex, customer facing visualizations and dashboards in Power BI or Tableau is a plus
• Experience working and modeling financial data sets and supporting source technologies (ERP/General Ledger systems, EPM/CPM systems such as Oracle OneStream) is a plus
• Excellent knowledge of relational databases (Oracle, SQL, etc.), complex SQL tuning, and data warehouse best practices

ABOUT SC&H

SC&H is a national consulting and financial services firm, home to people who believe in the power of trusted personal relationships. Everyone here shares a passion for driving results - a passion fueled by the genuine connections we forge. Our expert capabilities and exceptional service have shaped the firm's longstanding reputation for excellence and impressive growth. But it's the partnerships we foster and success we help deliver that make each day rewarding - for our colleagues, our clients, and our community.

SC&H has been deemed a "best place to work" by Inc., Baltimore Business Journal, Accounting Today, and Inside Public Accounting. In 2022, Inside Public Accounting recognized us as the fastest growing firm for organic growth in the United States. Our success is driven by 11 diverse practices at the intersection of finance, enterprise technology, and accounting, 400 employees, and a client base of rapidly growing startups to world-renowned Fortune 500 companies. This is the place to build lasting professional relationships, grow your skills, and fulfill your potential.

SC&H

Make it Rewarding.