Job Description

BTVK Advisory is a leading advisory firm whose specialized professionals guide clients through an ever-changing business world, helping them win now and anticipate tomorrow. BTVK Advisory, and its affiliated entities, have operations in North America, South America, Europe, Asia, and Australia. BTVK Advisory’s ultimate parent entity, Baker Tilly US, LLP, is an independent member of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 141 territories, with 43,000 professionals and a combined worldwide revenue of $5.2 billion.

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.

To be added to all ET through Experienced requisitions Any unsolicited resumes submitted through our website or to Baker Tilly Advisory Group, LP, employee e-mail accounts are considered property of Baker Tilly Advisory Group, LP, and are not subject to payment of agency fees. In order to be an authorized recruitment agency ("search firm") for Baker Tilly Advisory Group, LP, 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:

• Design, build, and maintain robust ETL/ELT pipelines to ingest, transform, and curate data from multiple source systems, ensuring scalability and reliability.
• Develop reusable and scalable data models optimized for analytics and reporting consumption, with a strong focus on data quality, performance, and timeliness.
• Troubleshoot and resolve data pipeline and data quality issues to ensure consistent and dependable data delivery.
• Partner with BI developers, analysts, and business stakeholders to deliver analytics-ready datasets for Power BI and Tableau, supporting semantic layer design and performance optimization.
• Assist in developing and optimizing dashboards, reports, and visualizations while ensuring consistent definitions, metrics, and governance across reporting platforms.
• Collaborate closely with analytics, product, and business teams to translate reporting requirements into well-structured and sustainable data solutions.
• Follow and contribute to data engineering standards, governance frameworks, documentation practices, and participate in code reviews, testing, and continuous improvement initiatives.
• Deliver projects using Agile or hybrid methodologies, manage tasks independently, provide accurate status updates, and proactively identify risks or dependencies.

Qualifications

• Bachelor’s degree required, preferably in Information Technology with a focus on Analytics, Data Science, or Statistics.
• Minimum 3 years of hands-on experience in data engineering, data integration, or analytics engineering roles.
• Strong proficiency in SQL, including the ability to develop complex queries and perform advanced data transformations.
• Practical experience supporting Power BI and/or Tableau, including data modeling for reporting and analytics use cases.
• Experience working with relational databases and cloud-based data platforms, including modern data ecosystems such as Databricks or cloud data warehouses (e.g., Snowflake, Redshift, BigQuery).
• Familiarity with data orchestration tools and CI/CD practices within data engineering environments.
• Exposure to Python or similar scripting languages for data processing, automation, and transformation.
• Solid understanding of data governance, data quality frameworks, metric standardization, and experience supporting AI, advanced analytics, or automation initiatives, coupled with strong analytical and problem-solving skills.