What are the responsibilities and job description for the Database Developer position at Calance?
Job Description
Our client, a leading provider of computing, applications management, IT procurement, network, and telecommunications services to public organizations, is looking to hire a Database Developer.
Key Responsibilities
. Experience in data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amount of data between multiple systems.
. Identifies data sources, provides data flow diagrams, and documents source to target mapping and process.
. Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Database environment.
. Power BI Development experience in Reports, Dashboards and DAX queries.
. Experience in Power BI Administration and/or Angular is a plus.
. Experience with Source Version Control software like GitHub and CICD pipelines
. Provide support after hours as an when needed.
Requirements and Skills
. 7 years of experience in Data Warehousing and Business Intelligence
. 5 Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
. 3-4 Years in SSIS and use of Stored Procedures.
. 3-4 Years in PowerBI Report Development
. Ingest and aggregate data from both internal and external data sources to build our data stage areas
. Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
. Strong experience with business intelligence and data warehousing design principles and industry best practices.
Preferred
. Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience.
Who is Calance?
Calance is a global IT company with operations in the United States, Canada and India. Over the years, Calance has grown organically and has acquired numerous successful IT Services firms along the way. As a result, the company today is a mix of diverse cultures, talents and expertise that collaborate globally to bring our best capabilities and thinking to clients. Calance also offers benefits which includes Medical, Dental, Vision care and 401K.
Calance - the place to grow.
Key Responsibilities
. Experience in data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amount of data between multiple systems.
. Identifies data sources, provides data flow diagrams, and documents source to target mapping and process.
. Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Database environment.
. Power BI Development experience in Reports, Dashboards and DAX queries.
. Experience in Power BI Administration and/or Angular is a plus.
. Experience with Source Version Control software like GitHub and CICD pipelines
. Provide support after hours as an when needed.
Requirements and Skills
. 7 years of experience in Data Warehousing and Business Intelligence
. 5 Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL
. 3-4 Years in SSIS and use of Stored Procedures.
. 3-4 Years in PowerBI Report Development
. Ingest and aggregate data from both internal and external data sources to build our data stage areas
. Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
. Strong experience with business intelligence and data warehousing design principles and industry best practices.
Preferred
. Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience.
Who is Calance?
Calance is a global IT company with operations in the United States, Canada and India. Over the years, Calance has grown organically and has acquired numerous successful IT Services firms along the way. As a result, the company today is a mix of diverse cultures, talents and expertise that collaborate globally to bring our best capabilities and thinking to clients. Calance also offers benefits which includes Medical, Dental, Vision care and 401K.
Calance - the place to grow.
Database Applications Developer
Resource Informatics Group, Inc -
Alpharetta, GA
SQL Database Developer
Tokio Marine HCC - Stop Loss Group -
Kennesaw, GA
Sr. PostgreSQL Database Developer
CGS Federal (Contact Government Services) -
Atlanta, GA
