Kyyba
Job Title:
Database Developer
Are you a
Database Developer
seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented
Database Developer
to join their growing team in
Atlanta, GA 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.
Job Description
Collaborate with internal customers, prospects, and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping.
Develop data integration routines that involve moving, cleansing, and transforming large amounts of data between multiple systems. Identify data sources, provide data flow diagrams, and document source-to-target mapping and processes. Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports. Provide technical enablement to team members developing database applications on a cloud platform. Lead small teams of 1-2 junior developers in data integration efforts, utilizing ETL design patterns, error handling, and configurations. Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security. Utilize Azure database tools and technologies, including Azure Data Studio and Azure Analytics Studio,to develop, maintain, and optimize database applications and solutions1. Collaborate with data stewards, data owners, and domain experts to adopt best practices in reporting and analysis, ensuring data integrity, test design, validation, and documentation. Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance. Establish processes for governing the identification, collection, and use of educational metadata to ensure accuracy and validity in business intelligence environments. Ensure data quality through audit controls, proactive monitoring, and data cleansing techniques. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment. Perform scheduled data process integrity checks, deployments, and coordinate releases. Utilize source version control software like GitHub and CICD pipelines. Provide on-call support after hours as needed. Requirements:
7+ years of experience in data warehousing and business intelligence. 5+ years in BI development leveraging Microsoft SQL Server, with expertise in T-SQL. 5+ years in SSIS and use of stored procedures. 3-5 years in Azure Data Factory, SQL VMs, and ETL development. Experience in ingesting and aggregating data from internal and external sources to build a data lake. Strong understanding of data modeling (conceptual, logical, and physical model design) and experience with operational data stores, enterprise data warehouses, and data marts. Deep understanding of relational database design concepts and SQL programming. • Experience in guiding and mentoring developers with less experience.
Strong analytical, conceptual, and problem-solving abilities. Experience with business intelligence and data warehousing design principles and industry best practices. Good to Have:
1-2 years in Azure Data Warehouse (Synapse). 1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud. Qualifications:
Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience. 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." It is the policy of Kyyba to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. If reasonable accommodation is needed, please contact Kyyba at 248-813-9665 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
Database Developer
Are you a
Database Developer
seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented
Database Developer
to join their growing team in
Atlanta, GA 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.
Job Description
Collaborate with internal customers, prospects, and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping.
Develop data integration routines that involve moving, cleansing, and transforming large amounts of data between multiple systems. Identify data sources, provide data flow diagrams, and document source-to-target mapping and processes. Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports. Provide technical enablement to team members developing database applications on a cloud platform. Lead small teams of 1-2 junior developers in data integration efforts, utilizing ETL design patterns, error handling, and configurations. Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security. Utilize Azure database tools and technologies, including Azure Data Studio and Azure Analytics Studio,to develop, maintain, and optimize database applications and solutions1. Collaborate with data stewards, data owners, and domain experts to adopt best practices in reporting and analysis, ensuring data integrity, test design, validation, and documentation. Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance. Establish processes for governing the identification, collection, and use of educational metadata to ensure accuracy and validity in business intelligence environments. Ensure data quality through audit controls, proactive monitoring, and data cleansing techniques. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment. Perform scheduled data process integrity checks, deployments, and coordinate releases. Utilize source version control software like GitHub and CICD pipelines. Provide on-call support after hours as needed. Requirements:
7+ years of experience in data warehousing and business intelligence. 5+ years in BI development leveraging Microsoft SQL Server, with expertise in T-SQL. 5+ years in SSIS and use of stored procedures. 3-5 years in Azure Data Factory, SQL VMs, and ETL development. Experience in ingesting and aggregating data from internal and external sources to build a data lake. Strong understanding of data modeling (conceptual, logical, and physical model design) and experience with operational data stores, enterprise data warehouses, and data marts. Deep understanding of relational database design concepts and SQL programming. • Experience in guiding and mentoring developers with less experience.
Strong analytical, conceptual, and problem-solving abilities. Experience with business intelligence and data warehousing design principles and industry best practices. Good to Have:
1-2 years in Azure Data Warehouse (Synapse). 1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud. Qualifications:
Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience. 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." It is the policy of Kyyba to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. If reasonable accommodation is needed, please contact Kyyba at 248-813-9665 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