Senior Data Engineer

Concord isn't your typical consulting firm; we are an execution company with a passion for making things happen. Our mission is to help clients enhance customer experiences, optimize operations, and revolutionize their product offerings through seamless integration, optimization, and activation of technology and data.

We are seeking a talented and experienced Senior Data Engineer to join our growing team. In this position, you will be responsible for the design, development, and deployment of extraction, transformation, and load (ETL) processes and methodologies to satisfy corporate data movements across various environments.

About the roleProficiency in Python, Spark, Java, SQL, DataOps.live/DBT, SnowflakePrior experience supporting Data Governance initiatives desired: Data Quality, Metadata Management (Data Cataloging, Data Lineage), Master Data Management, Data SecurityProficiency in other software engineering languages and/or methodologiesStrong knowledge of working Unix Shell scriptingProvide ongoing support for the existing ETL processes, procedures, as well as the ability to design, code and deploy new ETL packages to support application and business needs.Develop an effective working relationship with Data Analysts, Business Analysts, Database Administrators, and others in designing, developing, and implementing robust data movement solutions.Demonstrate the ability to translate business rules into ETL code while adhering to best ETL development and design practices.Demonstrate proficiency in SQL language, as well as working knowledge of common transformation methodologies, techniques, and tools.

Required Knowledge, Skills, and Experience Undergraduate degree with 10+ years of Data Engineering experience with specific ETL Tools (e.g., DBT, Informatica, Data Stage, etc.) or big data stackExperience in leading, hiring, developing, and building data engineering team and providing them with technical direction.Experience working with cloud technologies like Snowflake on Microsoft Azure, Amazon AWS or Google GCP Experience in reviewing and building dimensional data models to improve accessibility, efficiency and quality of data.Experience in building high quality applications, data pipelines and analytics solutions ensuring data privacy and regulatory compliance. Experience working with Business Stakeholders to understand requirements and ability to translate them into scalable and sustainable solutions. Should be proficient in writing Advanced SQLs, and expertise in performance tuning of SQLs in Snowflake.Demonstrate good understanding of development processes and agile methodologies. • Demonstrate honesty, integrity, and professionalism at all times.Excellent communication, customer service, and problem-solving skills.Exercise self-control under trying or tough circumstances, situations, or under any kind of pressureActively exchange ideas with others and build on their ideas to identify new solutions. • Outstanding planning & Organizational skillsAble to work independently or collaboratively and maintain a positive attitude.

Preferred Qualifications/Selection CriteriaBachelor of Engineering degree with 5-10+ years of Data Engineering experience with pertinent ETL tools (e.g., DBT, Informatica, Data Stage, etc.) or big data stackLead Data Warehouse/Business Intelligence development team in building Analytics solutionsLead the design of data pipeline/ETL using emerging technologies and tools.

If you are passionate about data engineering and have the skills to excel in this role, please submit your resume. Be sure to highlight your experience with Azure, ETL, SQL, and Python!