Kyyba
Senior Applications Developer
Kyyba, Boston, MA, United States
Job Description
JOB DUTIES (Detailed Statement of Duties and Responsibilities):
• Review the current database architecture, re-design & develop the new database to improve the efficiency,
usability and streamline data import and export processes.
• Develop advanced T-SQL code for implementing application business logic using stored procedures, views,
and functions.
• Document specific requirements for data integration, including file format, fields, etc.
• Develop ETL processes for the import and export of data between the DPH internal systems using SQL
Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined
functions, views, etc.
• Design, develop, revise, and maintain a wide variety of custom SSRS reports to support our business.
• Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports.
• Develop data warehouse objects and processes for the purpose of supporting business intelligence, including
ETL, fact/dimension tables, and cubes.
• Research, analyze, document, and maintain internal Applications and Database architectures.
Provide technical assistance and information to technical and non-technical users.
• Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper
data security standards set forth by the organization.
REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge):
• Analytical thinking
• Structured approach to problem skill with attention to details
• Self starter
• Communicate with technical and non-technical stakeholders
• Good customer service skills
QUALIFICATIONS (Education, Years' Experience, Certificates):
• Bachelor's degree in Computer Science, Computer Information Systems, Information Management or equivalent
work experience
• Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms,
Data Warehousing...
• 10 Years working in a data centric IT environment.
• 5 years hands on experience with ETL tools and integration engines, preferably MS SSIS, Snowflake
• Proven track record of designing and implementing complex and large scale Enterprise Databases
• Documenting databases using Entity Relationship Models and Data Dictionaries
• Writing SQL scripts
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
JOB DUTIES (Detailed Statement of Duties and Responsibilities):
• Review the current database architecture, re-design & develop the new database to improve the efficiency,
usability and streamline data import and export processes.
• Develop advanced T-SQL code for implementing application business logic using stored procedures, views,
and functions.
• Document specific requirements for data integration, including file format, fields, etc.
• Develop ETL processes for the import and export of data between the DPH internal systems using SQL
Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined
functions, views, etc.
• Design, develop, revise, and maintain a wide variety of custom SSRS reports to support our business.
• Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports.
• Develop data warehouse objects and processes for the purpose of supporting business intelligence, including
ETL, fact/dimension tables, and cubes.
• Research, analyze, document, and maintain internal Applications and Database architectures.
Provide technical assistance and information to technical and non-technical users.
• Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper
data security standards set forth by the organization.
REQUIRED SKILLS (Special Skill Set, Abilities, Knowledge):
• Analytical thinking
• Structured approach to problem skill with attention to details
• Self starter
• Communicate with technical and non-technical stakeholders
• Good customer service skills
QUALIFICATIONS (Education, Years' Experience, Certificates):
• Bachelor's degree in Computer Science, Computer Information Systems, Information Management or equivalent
work experience
• Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms,
Data Warehousing...
• 10 Years working in a data centric IT environment.
• 5 years hands on experience with ETL tools and integration engines, preferably MS SSIS, Snowflake
• Proven track record of designing and implementing complex and large scale Enterprise Databases
• Documenting databases using Entity Relationship Models and Data Dictionaries
• Writing SQL scripts
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