Data Warehouse Engineer / ETL Developer - Software Guidance & Assistance
Raleigh, NC
About the Job
Software Guidance & Assistance, Inc., (SGA), is searching for an Data Warehouse Engineer / ETL Developer for a FULL TIME assignment with one of our premier Mortgage Insurance clients in Raleigh, NC.
**Hybrid, twice-a-week role at our Raleigh office**
The Data Warehouse Engineer, will specialize in designing, implementing, and optimizing database systems for efficient storage, retrieval, and management of structured data.
Join us as we embark on an exciting modernization journey, transitioning from our legacy platforms to cutting-edge technologies like Power BI and Snowflake. We're seeking passionate individuals to drive this transformation, leveraging their expertise to revamp our data infrastructure and propel us into the future.
Responsibilities :
1. Works with the Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately capture stakeholder requests and system specifications and translate them into engineering artifacts, which typically include design specifications, source code, test scripts and test results.
2. Coordinates with software architects and Software engineer IVs to ensure that the engineering realization is in accordance with Enterprise Architecture principles and software development best practices.
3. As part of Agile teams, completes software development work which includes application design, coding, code review and testing. Keeps Agile team and APM apprised of project status.
4. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives.
5. Manages engineering risks by proactively tracking and communicating issues and devising methods to mitigating them.
6. Liaises with other project and program areas to coordinate interdependencies and resolve issues.
7. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA's.
8. Maintains a working knowledge of new technology and software engineering standards, practices and tools.
9. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates
10. Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates.
Required Skills:
1. Strong understanding of data warehouse concepts and experience with different modeling approaches like DVM, Kimball etc.
2. Experience in cloud data architecture that supports advanced analytics including Snowflake, Azure
3. 5-7 years of experience in developing reports, preferably using Power BI.
4. 5-7 years of experience in ETL using SSIS or similar technologies.
5. Strong SQL knowledge and hands on experience working with structured & semi-structured databases like SQL server, DB2 & Mongo.
6. Hands on experience in administering Cognos (Installation/Configuration, Security Setup, Scheduling, Data Source setup) & Power BI (Gateway installation/Configuration, Creating connections).
7. Hands on experience in DataOps.
8. Excellent analytical, problem solving and organizational skills.
9. Excellent interpersonal, and written and oral communication skills.
10. Strong customer service skills to provide end user/business owner systems support.
11. Knowledge of production support processes such as incident and problem management techniques.
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
**Hybrid, twice-a-week role at our Raleigh office**
The Data Warehouse Engineer, will specialize in designing, implementing, and optimizing database systems for efficient storage, retrieval, and management of structured data.
Join us as we embark on an exciting modernization journey, transitioning from our legacy platforms to cutting-edge technologies like Power BI and Snowflake. We're seeking passionate individuals to drive this transformation, leveraging their expertise to revamp our data infrastructure and propel us into the future.
Responsibilities :
1. Works with the Agile Program Manager (APM), Digital Product Manager (DPM), and Business Systems Analyst (BSA) to accurately capture stakeholder requests and system specifications and translate them into engineering artifacts, which typically include design specifications, source code, test scripts and test results.
2. Coordinates with software architects and Software engineer IVs to ensure that the engineering realization is in accordance with Enterprise Architecture principles and software development best practices.
3. As part of Agile teams, completes software development work which includes application design, coding, code review and testing. Keeps Agile team and APM apprised of project status.
4. Offers suggestions to stakeholders on devising effective and efficient approaches to achieve project and program objectives.
5. Manages engineering risks by proactively tracking and communicating issues and devising methods to mitigating them.
6. Liaises with other project and program areas to coordinate interdependencies and resolve issues.
7. Supports business units in the resolution of in-depth user questions and issues following production support process and SLA's.
8. Maintains a working knowledge of new technology and software engineering standards, practices and tools.
9. Provides input to APM/DPM in creation of Product Roadmap, High Level Estimates
10. Collaborates with IT management to define and develop documentation & engineering artifact standards, guidelines, processes, and templates.
Required Skills:
1. Strong understanding of data warehouse concepts and experience with different modeling approaches like DVM, Kimball etc.
2. Experience in cloud data architecture that supports advanced analytics including Snowflake, Azure
3. 5-7 years of experience in developing reports, preferably using Power BI.
4. 5-7 years of experience in ETL using SSIS or similar technologies.
5. Strong SQL knowledge and hands on experience working with structured & semi-structured databases like SQL server, DB2 & Mongo.
6. Hands on experience in administering Cognos (Installation/Configuration, Security Setup, Scheduling, Data Source setup) & Power BI (Gateway installation/Configuration, Creating connections).
7. Hands on experience in DataOps.
8. Excellent analytical, problem solving and organizational skills.
9. Excellent interpersonal, and written and oral communication skills.
10. Strong customer service skills to provide end user/business owner systems support.
11. Knowledge of production support processes such as incident and problem management techniques.
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at https://sgainc.com/ .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company EEO page to request an accommodation or assistance regarding our policy.
Source : Software Guidance & Assistance
