Shire Jobs

Overview Baker Tilly US, LLP (Baker Tilly) is a leading advisory CPA firm, providing clients with a genuine coast-to-coast and global advantage in major regions of the U.S. and in many of the world's leading financial centers - New York, London, San Francisco, Los Angeles and Chicago. Baker Tilly is an independent member of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 145 territories, with 41,000 professionals and a combined worldwide revenue of $4.7 billion. Please discuss the work location status with your Baker Tilly talent acquisition professional to understand the requirements for an opportunity you are exploring. Baker Tilly is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, gender identity, sexual orientation, or any other legally protected basis, in accordance with applicable federal, state or local law. Any unsolicited resumes submitted through our website or to Baker Tilly US, LLP, employee e-mail accounts are considered property of Baker Tilly US, LLP, and are not subject to payment of agency fees. In order to be an authorized recruitment agency ("search firm") for Baker Tilly US, LLP, there must be a formal written agreement in place and the agency must be invited, by Baker Tilly's Talent Attraction team, to submit candidates for review via our applicant tracking system. Responsibilities Baker Tilly has an incredible career opportunity for an Associate Data Engineer to join our growing Enterprise Technology team. The Associate Data Engineer role will be focused specifically on Data Warehousing, Data Management, BI and Data Analytics. All supporting the need to define the businesses strategy and bring light and understanding to the vast amounts of data that Baker Tilly utilizes.

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure technologies
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc
• Utilize development best practices including technical design reviews, implementing test plans, monitoring/alerting, peer code reviews, and documentation
• Work with our developers to implement data solutions in SQL Server (both on-premises and Azure instances)
• Work with the team to develop our Databricks data lakehouse environment for firmwide usage within applications, data integrations, and reporting solutions.

Qualifications

• Strong understanding of data modeling, algorithms, and data transformation techniques.
• Well versed in BI and data analytics, SQL, Python, R, the MS Stack, Azure and other cloud services
• Databricks Lakehouse Platform and Boomi MDH skills are preferred
• Experience developing, deploying and supporting high-quality, fault-tolerant data pipelines
• Have hands on experience in Microsoft business intelligence technologies.
• Exhibit responsibility and accountability towards quality completion of projects and consistently hitting project timelines.
• Outstanding customer service skills following proper business requirements and human resources expectations
• Disciplined to be able to work in a variety of business environments.
• Maintained a Bachelor's degree in Computer Science, Engineering, Math, Information Technology, or other related discipline or 4 + years of commensurate experience.

Additional Information #LI-KK1