Data Cloud Architect

Cloud EngineerCloud EngineerFull TimeRemoteTeam 10,001+Since 1903H1B SponsorCompany Site LinkedIn

Location

Michigan

Posted

39 days ago

Salary

$158.4K - $195.9K / year

Bachelor Degree7 yrs expEnglishBig QueryCloudCognosETLGoogle Cloud PlatformInformaticaOraclePythonSQLTableauTerraformVBA

Job Description

• Provide technical stability and anchoring for a team of data scientists, data engineers, and BI specialists. • Design and architect highly scalable and performant data solutions on GCP, leveraging services such as BigQuery, Dataflow, Dataproc, and Cloud Storage. • Develop and maintain CI/CD pipelines using Tekton, ensuring automated deployments to Cloud Run and other GCP services. • Implement robust data governance and security policies, adhering to OIC compliance standards. • Develop and maintain Terraform infrastructure-as-code for consistent and repeatable deployments. • Collaborate with stakeholders to define and implement key performance indicators (KPIs) and metrics. • Oversee data modeling, data warehousing, and data lake design and implementation. • Champion the adoption of best practices in data engineering and data architecture. • Utilize GitHub for version control, code review, and collaborative development. • Work closely with BI specialists to create interactive dashboards and reports using Looker, Data Studio, and other BI tools. • Manage and mentor team members, fostering a collaborative and innovative environment.

Job Requirements

Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, Data Engineering, Data Science or a related field and 7 years of progressive, post-baccalaureate experience in the job offered or a related occupation.
7 years of experience with each of the following skills is required:
1. Analyzing different Data Sources including DB2, SQL Server, Oracle and Flat files from which data is coming and understand the relationships by analyzing the source and build solution architecture.
2. Application of data warehousing, data lake architectures, and advanced data modeling techniques.
3. Utilizing SQL and Python programming languages for complex data processing, transformation, analysis, and automation tasks, integrated with version control (Git), CI/CD practices, and preparing data for consumption by Business Intelligence (BI) tools (Looker and Tableau).
3 years of experience with each of the following skills is required:
1. Using Tableau, Power BI, and IBM Cognos Analytics BI tools to develop numerous custom business intelligence reports, dashboards, and data extracts for business units/departments including Capital Markets, Secondary Markets, Quantitative Risk Management, Mortgage Subservicing, Mortgage Servicing, and Mortgage Origination.
2. Creating GitHub repository to manage ETL DataStage/Informatica and PL/SQL code versions.
3. Creating Python programs to parse and load complex source data into a target database.
4. Using Microsoft Access, SQL, and VBA to develop databases, data queries, reports, logic statements, database business rules, and graphical user interfaces (forms) for data entry by business users.

Benefits

Immediate medical, dental, and prescription drug coverage**
Flexible family care, parental leave, new parent ramp-up programs, subsidized back-up child care and more**
Vehicle discount program for employees and family members, and management leases**
Tuition assistance**
Established and active employee resource groups**
Paid time off for individual and team community service**
A generous schedule of paid holidays, including the week between Christmas and New Year's Day**
Paid time off and the option to purchase additional vacation time.****