Sr. Data Warehouse Analyst - Kennesaw, United States - Insight Global

Description

Job Description

Insight Global is assisting a client with finding a Data Warehouse Developer for a contract to hire opportunity north of Atlanta, GA.

This position requires a hybrid schedule onsite 3X a week to work closely with team and end users. In this role, you will design, develop, install, maintain, and support our enterprise data warehouse system, including data marts.

You should have a strong understanding of end user tool sets used for accessing an Enterprise Decision Support System, with a focus on SQL Server and Analysis Services.

Responsibilities include collaborating closely with financial teams, running reports with MDX, ensuring regular recalculation of the data warehouse, and working with SQL Server's relational database to optimize performance.

You will also interact with business stakeholders, adapt the data warehouse to evolving needs, and script and maintain stored procedures for data loading and calculations.

• Own and develop relationships with end users, working with them to optimize and enhance existing reports and integrations
• Design and improve current ETL processes by writing code for database access, modifications, and construction including stored procedures and extract/transfer/load (ETL) packages to integrate new or existing data sources.
• Create and modify SISS Packages as needed (C# scripting language used)
• Write and modify SSRS Reports
• Determine logical and physical architecture requirements necessary to integrate new or existing sources into an Enterprise Business Intelligence (data warehouse) system.
• Create logical and physical models for new database development and/or changes to existing ones.
• Review, evaluate, design, test, implement, and maintain company database(s) to support the organizations data needs for Business Intelligence Architecture and Data Integration.
• Install and configure relevant software components to ensure the success of Business Intelligence Architecture and Data Integration processes, accessibility, and availability.
• Consult with clients and team members to obtain requirements needed for constructing business intelligence architectures
• Create standards for installation, operational support, and information security for Business Intelligence, and Data Integration to adhere to corporate IT standards.
• Integrate Change Data Capture software to monitor transaction data from source systems.
• Integrate new data with existing warehouse structure and continuously improves how the system functions.
• Deliver Business Intelligence Solutions using Microsoft technology such as SharePoint, Excel, Analysis Services, Reporting Services, and others.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day.

We are an equal opportunity/affirmative action employer that believes everyone matters.

Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to .

To learn more about how we collect, keep, and process your private information, please review Insight Global's

Workforce Privacy Policy:
om/workforce-privacy-policy/ .
Skills and Requirements

• 5+ years' experience as a Data Warehouse Developer
• MDX (query language designed for OLAP databases)
• Solid SSAS (sql server analysis services)

• Strong in Mathematics

• Strong SQL server (scripting, writing stored procedures)
• SSIS Integration
• Cloud azure

* power BI

• Accounting knowledge null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day.

We are an equal employment opportunity/affirmative action employer that believes everyone matters.

Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to