What we would like to see :
Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results.
Incumbent's responsibilities will include conducting full development lifecycle requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.
We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.
A typical day as a senior data warehouse developer :
Design and develop ETL and reporting processes using SSIS / SSRS tools based on established enterprise standards
Engage with business units to gather requirements and perform iterative data analysis in a fast paced agile environment
Architect SQL Server database structures and objects, fine tune SQL queries for performance and monitor latencies during batch processes
Identify, analyze, and interpret trends or patterns in complex data sets
Design and develop reports, and flat file extracts for consumption by business users and external vendors
Collaborate with management to prioritize business and information needs
Find and evaluate new process improvement opportunities
What you will need to bring to the table :
8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques
Solid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performance
Solid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business Objects
Strong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skills
Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Good knowledge of documentation and code versioning
Good knowledge of working with enterprise automation tools
BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates
Complimentary skills sets like background in Java programming, Python and / or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus!
Data Warehouse Developer
As an experienced data warehouse developer, you will be joining a collaborative IT data warehouse team as we bring Guidehouse data together to meet our business's reporting needs. Participate in development and maintenance of our corporate data warehouse and data lake as a member of our corporate da...
Operations & Technology Transformation, Guidewire Developer - ETL/Data Migration - Senior Consultant
Senior Consultant, Operations & Technology Transformation, Insurance, Guidewire Developer - ETL/Data Migration. Data Mapping or Data Migration experience. Candidates should be energized by continuous personal improvement, proactively seeking out new skills and perspectives, exhibiting openness t...
Database Developer (Data Warehouse)
The purpose of this EXCITING NEW position is to design and build components of a data warehouse (DW) to support business intelligence and data science initiatives. Designs and builds data warehouses and reporting solutions. Designs and develops Extract, Transform and Load (ETL) solutions to populate...
Senior Data Warehouse Developer
A typical day as a senior data warehouse developer:. ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques. Incumbent's responsibilities will include conducting full development li...
Senior Data Developer
This role will focus on enhancing our data warehouse and spearheading new initiatives, security enhancements, and the ingestion of new data sources. Lead and execute data warehouse enhancement projects and new data initiatives. Familiarity with cloud platforms, especially Azure Data Cloud, including...
Operations & Technology Transformation Senior Consultant, Guidewire Data Migration - ETL Developer
Operations & Technology Transformation Senior Consultant, Guidewire Data Migration - ETL Developer. We implement innovative technology solutions spanning core, digital, data, analytics, cloud and AI. As an OTT Insurance Transformation Senior Consultant, you will bring considerable technical expertis...
Backend Developer/Senior Data Engineer
Job Title: Backend Developer/Data Engineer (Senior/Staff equivalent). Build tooling to monitor data pipelines and perform troubleshooting and debugging to identify and resolve data quality and performance issues. Collaborate with data scientists, analysts, and other stakeholders to understand their ...
Data Warehouse Developer
We’re looking for a motivated Data Warehouse Developer responsible for preparing corporate data for reporting and analysis using the relational database and OLAP technologies. Maintains data integrity by reducing data redundancy, trends in data use and single sources of data. This position will anal...
Senior Application Developer - Data Integration Services
As a member of the Medicaid Data Integration team, you will provide value to customers by delivering outstanding integration solutions. In this role you will have hands on experience in the full development lifecycle, working with diverse data formats on industry leading technology, like Informatica...
Power BI Developer
The Power BI Developer will be a member of the Operations Technology Team who manages the development and maintenance of our Power BI environment. This includes working with all stakeholders to maintain and improve existing Power BI objects as needed, as well as, working to develop new Power BI requ...