Kyyba
Senior DW Architect expertise in Snowflake & Informatica
Kyyba, Boston, Massachusetts, us, 02298
Job Description
Understand and translate business requirements into Data Warehouse solutions Create data models and designs to meet specific business needs that require sourcing data from multiple source systems Develop ETL / ELT / Data pipelines that will extract data from an operational database and populate the staging and target data warehouse schemas Document code and processes for distribution to all interested parties Document design using industry standards Provide query writing support and tuning expertise to analysts and end users Develop shell scripts for production job automation Work in a 24x7 environment which requires on-call rotation
EXPERIENCE AND EDUCATION:
10+ years of experience in database development including analysing, designing, documenting, coding, testing and implementing primarily SQL code Experience working with a large, multi-terabyte data warehouse Experience with system administration, database administration, storage architectures, backup & recovery and networking Medicaid or other healthcare or claims processing experience Snowflake Data Warehouse experience Informatica ETL experience AWS (Cloud) Experience Exadata Experience Cognos 10.3 reporting experience BS in Computer Science or related degree, or equivalent experience
QUALIFICATIONS: (Special Skill Set, Knowledge, Certifications)
Thorough knowledge of data warehouse principles and techniques, specifically dimensional data Exceptional Oracle SQL skills Hands on experience with set based operations, analytic functions and query hints Command of data warehouse modeling concepts is required Strong problem solving and analytical skills Proficiency with Linux and shell scripting
About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances. At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development. Disclaimer: Kyyba is an Equal Opportunity Employer. Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need. Rewards: Medical, dental, vision 401k Term life Voluntary life and disability insurance Optional Pre-paid legal plan Optional Identity theft plan Optional Medical and dependent FSA Work-visa sponsorship Opportunity for advancement Long-term assignment with opportunity for hire by client
SELECT AWARDS
An INC 5000 company for 10 years Corp! Michigan Economic Bright Spots Crain's Detroit Business Top Staffing Service Companies in Detroit TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions Best of MichBusiness winner in HR Wizards & Partnerships Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest 101 Best & Brightest Companies to Work for in Michigan
Understand and translate business requirements into Data Warehouse solutions Create data models and designs to meet specific business needs that require sourcing data from multiple source systems Develop ETL / ELT / Data pipelines that will extract data from an operational database and populate the staging and target data warehouse schemas Document code and processes for distribution to all interested parties Document design using industry standards Provide query writing support and tuning expertise to analysts and end users Develop shell scripts for production job automation Work in a 24x7 environment which requires on-call rotation
EXPERIENCE AND EDUCATION:
10+ years of experience in database development including analysing, designing, documenting, coding, testing and implementing primarily SQL code Experience working with a large, multi-terabyte data warehouse Experience with system administration, database administration, storage architectures, backup & recovery and networking Medicaid or other healthcare or claims processing experience Snowflake Data Warehouse experience Informatica ETL experience AWS (Cloud) Experience Exadata Experience Cognos 10.3 reporting experience BS in Computer Science or related degree, or equivalent experience
QUALIFICATIONS: (Special Skill Set, Knowledge, Certifications)
Thorough knowledge of data warehouse principles and techniques, specifically dimensional data Exceptional Oracle SQL skills Hands on experience with set based operations, analytic functions and query hints Command of data warehouse modeling concepts is required Strong problem solving and analytical skills Proficiency with Linux and shell scripting
About Kyyba: Founded in 1998 and headquartered in Farmington Hills, MI, Kyyba has a global presence delivering high-quality resources and top-notch recruiting services, enabling businesses to effectively respond to organizational changes and technological advances. At Kyyba, the overall well-being of our employees and their families is important to us. We are proud of our work culture which embodies our core values; incorporating value, passion, excellence, empowerment, and happiness, creates a vibrant and productive atmosphere. We empower our employees with the resources, incentives, and flexibility that they need to support a healthy, balanced, and fulfilling career by providing many valuable benefits and a balanced compensation structure combined with career development. Disclaimer: Kyyba is an Equal Opportunity Employer. Kyyba does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. Minorities / Females / Protected Veterans / Individuals with Disabilities are encouraged to apply. All employment is decided on the basis of qualifications, merit, and business need. Rewards: Medical, dental, vision 401k Term life Voluntary life and disability insurance Optional Pre-paid legal plan Optional Identity theft plan Optional Medical and dependent FSA Work-visa sponsorship Opportunity for advancement Long-term assignment with opportunity for hire by client
SELECT AWARDS
An INC 5000 company for 10 years Corp! Michigan Economic Bright Spots Crain's Detroit Business Top Staffing Service Companies in Detroit TechServe Alliance Excellence Award- IT and Engineering Staffing & Solutions Best of MichBusiness winner in HR Wizards & Partnerships Metro Detroit Elite Category: Recruitment, Selection & Orientation for 101 Best & Brightest 101 Best & Brightest Companies to Work for in Michigan