Ford Senior Data Engineer - SQL Server BQ 

India, Tamil Nadu, Chennai 

702260582

Position Description:

We’re seeking a Data Engineer who has experience building data products on a SQL Server analytics and BigQuery platforms. You will work on ingesting, transforming, and analyzing large datasets to support the Enterprise in the Data Factory on Google Cloud Platform (GCP). Experience with large scale solution and operationalization of data lakes, data warehouses, and analytics platforms on Google Cloud Platform or other cloud environments is a must. We are looking for candidates who have a broad set of technical skills across these areas.

You will:

• Work in collaborative environment that leverages paired programming
• Work on a small agile team to deliver curated data products
• Work effectively with fellow data engineers, product owners, data champions and other technical experts
• Demonstrate technical knowledge and communication skills with the ability to advocate for well-designed solutions
• Develop exceptional analytical data products using both streaming and batch ingestion patterns on Google Cloud Platform with solid data warehouse principles
• Be the Subject Matter Expert in Data Engineering with a focus on GCP native services and other well integrated third-party technologies

Primary Skills Required:

• Experience in working in an implementation team from concept to operations, providing deep technical subject matter expertise for successful deployment. Implement methods for automation of all parts of the pipeline to minimize labor in development and production
• Experience in analyzing complex data, organizing raw data, and integrating massive datasets from multiple data sources to build analytical domains and reusable data products
• Experience in working with architects to evaluate and productionalize data pipelines for data ingestion, curation, and consumption
• Experience in working with stakeholders to formulate business problems as technical data requirements, identify and implement technical solutions while ensuring key business drivers are captured in collaboration with product management

Additional Skills Preferred:

• Strong drive for results and ability to multi-task and work independently
• Self-starter with proven innovation skills
• Ability to communicate and work with cross-functional teams and all levels of management
• Demonstrated commitment to quality and project timing
• Demonstrated ability to document complex systems
• Experience in creating and executing detailed test plans

Experience Required:

• 2+ years of Google cloud experience with solutions designed and implemented at production scale
• 5+ years of SQL Server Analytics experience with solutions designed and implemented at production scale
• 5+ years of SQL development experience
• 5+ years of analytics/data product development experience required
• Experience working in SQL Server Integration, Analytics and Reporting services
• Experience working in GCP native (or equivalent) services like Big Query, Google Cloud Storage, PubSub, Dataflow, Dataproc, Cloud Build, etc.
• Experience migrating Teradata to GCP
• Experience working with Airflow for scheduling and orchestration of data pipelines
• Experience working with Terraform to provision Infrastructure as Code

Additional Experience Preferred

• Experience converting Microsoft SSRS, SSAS and SSIS to BQ
• Professional development experience in Java or Python
• Experience converting Mainframe JCL , COBOL and CA7
• Experience converting SAS code to BQ
• Experience converting Web Focus reports in to Qlik Sense
• In-depth understanding of Google’s product technology (or other cloud platform) and underlying architectures
• Experience in working with DBT/Dataform
• Experience with DataPlex or other data catalogs is preferred
• Experience with development eco-system such as Tekton, Git, Jenkins for CI/CD pipelines
• Exceptional problem solving and communication skills
• Experience in working with Agile and Lean methodologies
• Team player and attention to detail
• Experience with performance tuning SQL queries

Education Required:

• Bachelor’s degree in computer science or related scientific field

Additional Education Preferred

• GCP Professional Data Engineer or Microsoft SQL Server Analytics Engineer Certified
• Master’s degree in computer science or related field
• 2+ years mentoring engineers
• In-depth software engineering knowledge