Senior Datawarehouse Engineer - Hybrid Role

Armanino Mckenna Certified Public Accountants & Consultants San Jose , CA 95111

Posted 3 weeks ago

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about.

SENIOR DATAWAREHOUSE ENGINEER - Hybrid role

(HYBRID ROLE TO ANY ARMANINO OFFICE - DALLAS, AUSTIN, DENVER, LOS ANGELES, IRVINE, SAN RAMON, SAN JOSE, CHICAGO, PHILADELPHIA, NEW YORK, NASHVILLE)

Armanino is proud to be Among the top 20 Largest Firms in the Nation and one of the Best Places to Work. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career. At Armanino, we know you don't check-out of life when you check-in at work. That's why we've created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

Job Responsibilities

  • Responsible for end-to-end data integration in the Azure platform, this includes all phases of integration development life cycle, requirements gathering, design, build, test, deploy and maintenance.

  • Assist in providing ongoing technical support and maintenance of existing integrations.

  • Develops and operationalizes data pipelines to make data available for consumption (BI, Advanced analytics, Services).

  • Works in tandem with business analysts, data architect and data/BI engineers to design data pipelines and recommends ongoing optimization of data storage, data ingestion, data quality and orchestration.

  • Design and implement complex data models on Azure Synapse Analytics to support data warehousing and big data solutions.

  • Utilize Azure DevOps for continuous integration, continuous delivery, and agile project management.

  • Manage and optimize Apache Spark pools for high-performance data processing tasks.

  • Develop and maintain ETL processes and data pipelines using Python scripting.

  • Ensure data quality and integrity across all platforms and systems. Purview experience would be preferable.

  • Designs, develops, and implements ETL/ELT processes using Azure Data Factory, Synapse pipelines, Databricks Notebooks, Event Hub to build integrations from Saas sources such as Service Now, Workday, Dynamics CRM, and Eloqua.

  • Uses Azure services such as Synapse Analytics, Synapse pipelines, Lakehouse, Fabric, ADLS, Azure Event Hub, and Azure Data Factory to improve and speed up delivery of our data products and services.

  • Experienced in big data and NoSQL solutions by developing scalable data processing platforms to drive high-value insights to the organization.

  • Identifies, designs, and implements internal process improvements (automating manual processes, optimizing data delivery).

  • Identifies ways to improve data reliability, efficiency, and quality of data management.

  • Communicates technical concepts to non-technical audiences both in written and verbal form.

  • Manage and provide leadership for the resources supporting the break/fix efforts for data Integrations.

  • Act as primary point of contact to monitor and triage Datawarehouse related IT issues.

  • Strong collaboration and communication skills including the ability to bring together various teams and resources to deliver results.

Requirements

  • BA/BS in Computer Science, Engineering, or equivalent software/services work experience.

  • Minimum 5 years' experience engineering with Azure Synapse and operationalizing data pipelines with large and complex datasets.

  • Minimum 5 years' experience in data engineering with a proven track record in the Azure ecosystem and with Azure DevOps.

  • Minimum 5 years' experience with Data Modeling, ETL, and Data Warehousing

  • Minimum 3 years' hands on experience with Azure Services. Azure certifications preferred.

  • Minimum 3 years' experience working with Cloud technologies such as Synapse pipelines, Azure Data Factory (ADF), ADLS, Azure Databricks, Spark, Azure Synapse, and other modern data ETL/ELT technologies.

  • Advanced Python and SQL skills required. Solid understanding of relational databases and business data; ability to write complex SQL queries against a variety of data sources.

  • Experience with other technologies such as Workday, Service Now, Eloqua, Microsoft CRM.

  • Extensive experience working with various data sources (SQL, Oracle database, flat files (csv, delimited), Web API, XML.

  • Experience delivering data solutions through agile software development methodologies.

  • Strong understanding of database storage concepts (data lake, relational databases, NoSQL, Graph, data warehousing).

  • Excellent verbal and written communication skills.

  • Able to work in a fast-paced agile development environment.

  • Ability to work onsite, as a hybrid employee to any one of the Armanino offices.

Armanino LLP provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino LLP complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Armanino LLP expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Armanino LLP's employees to perform their job duties may result in discipline up to and including discharge.

Certain states require us to disclose the pay range and benefits summary for job openings. Compensation Range for this position: $168,000-$250,000 annually. Compensation may vary based on skills, role, and location.

Armanino has a robust offering of benefits, including:

  • Medical, dental, vision

  • Generous PTO plan

  • Flexible work arrangements

  • 401K with Profit Sharing

  • Wellness program

  • Generous parental leave

For positions based in San Francisco, consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration.

For Individuals who would be working within the City of Los Angeles, Armanino will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

To view our Consumer Notice at Collection for job applicants, please visit: https://www.armanino.com/terms/ccpa-employee-notice/

#LI-ML1

We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Datawarehouse Engineer Hybrid Role

Armanino Mckenna Certified Public Accountants & Consultants

Posted 3 weeks ago

VIEW JOBS 5/22/2024 12:00:00 AM 2024-08-20T00:00 At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about. SENIOR DATA Armanino Mckenna Certified Public Accountants & Consultants El Segundo CA

Senior Datawarehouse Engineer - Hybrid Role

Armanino Mckenna Certified Public Accountants & Consultants