lead data warehouse engineer (remote)
Randstad
Remote
lead
data
data warehouse
warehouse
engineer
remote
data
data warehouse
warehouse
cloud
production
design
aws
November 22, 2022
Randstad
Pasadena, California
CONTRACTOR
summary
$61.25 - $65.33 per hour
temp to perm
bachelor degree
category
computer and mathematical occupations
reference
983107
job summary:
The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands-on experience in a multitude of data domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud data warehouse and reporting solutions and management, design and build data warehouse models, ETL development, performance tuning, service delivery, incident tracking, and change management.
Job Requirements
location: remote, California
job type: Contract
salary: $61.25 - 65.33 per hour
work hours: 8am to 4pm
education: Bachelors
responsibilities:
qualifications:
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
We 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.
For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.
The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands-on experience in a multitude of data domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud data warehouse and reporting solutions and management, design and build data warehouse models, ETL development, performance tuning, service delivery, incident tracking, and change management.
Job Requirements
- Bachelors and/or Masters degree in Computer Science, Computer Engineering or related field preferred
8+ years of overall software development experience is required primarily with Data warehouse and Business Intelligence applications
4+ years of hands-on development experience in MPP cloud-based data warehouse platform AWS Redshift, Snowflake or Azure SQL Data Warehouse or Synapse platform
4+ years of hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc.); experience with complex stored procedures and functions using SQL, optimization of SSIS packages and Redshift database queries
Windows batch scripting, Shell scripting and working experience with Python and/or Java- strong knowledge and experience in OLAP data modeling & design
Demonstrated expertise in performance tuning in various DB environments with large volumes of data
Experience building and scaling distributed, high available systems in cloud env (Azure / AWS)
Expertise in understanding complex business needs, analyzing, designing, and developing solutions
Communication and professional skills and the ability to navigate relationships across business units
location: remote, California
job type: Contract
salary: $61.25 - 65.33 per hour
work hours: 8am to 4pm
education: Bachelors
responsibilities:
- Architecting and maintaining the Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories
Designing and implementing performance data movement pipelines using multiple ETL tools with batch and real-time event data streams (Informatica, SQL Packages, Apache Kafka, Azure Event Hub, AWS Kinesis, etc.)
Gathering business and information requirements from various product owners across various functional units
Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models
Conducting design review sessions and communicate design artifacts with stakeholders
Ensures database features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability
Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders
Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks
Leading and coordinating the design and operationalization of Master Data Management and Data Governance initiatives including custom developed solutions
Working with other members of the project team to support delivery of additional project components associated with cloud data platform
Participate on a rolling production support schedule, fixing/restarting job failures, and working on improving production stability and consistency
Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention
Perform other duties as assigned including major new project initiatives
qualifications:
- Experience level: Experienced
Minimum 8 years of experience
Education: Bachelors
skills:
- Data Warehouse (8 years of experience is required)
Team Lead or Tech Lead (1 year of experience is required)
Redshift or Snowflake (4 years of experience is required)
AWS or Azure (3 years of experience is required)
Python or Java (3 years of experience is required)
SSIS (4 years of experience is required)
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [email protected].
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
We 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.
For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.
Report this job
Similar jobs near me
Related articles
- The Importance of Inventory Management System for Businesses
- Challenges of Becoming a Construction Manager Without a Degree
- Manage the Move: The Path to a Career as a Transportation, Storage, and Distribution Manager
- The Ultimate Guide to Project Manager’s Career
- The A to Z Guide to Marketing Management: Everything You Need to Know to Succeed