- 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.
- 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
- Accounting knowledge
-
Senior Data Warehouse Analyst
3 weeks ago
Tokio Marine HCC Kennesaw, United StatesTokio Marine HCC (TMHCC) brings 50 years of service to the specialty insurance industry, today offering over 100 products to commercial customers in 180 countries around the world. Organic growth and over 60 successful acquisitions have grown our 2022 Gross Written Premium (GWP) ...
-
Sr. Data Warehouse Analyst
4 weeks ago
Insight Global Kennesaw, United StatesJob 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 ...
-
Cost / Pricing Analyst
1 week ago
Hire Military Talent Kennesaw, United StatesCost / Pricing Analyst · Responsible for cost reporting and analysis, auditing logistics supplier invoices, and providing KPI reports on distribution operations. · MAIN ACCOUNTABILITIES: · Audit all 3PL and logistics supplier invoices to ensure rate structure and pricing charg ...
-
TIBCO Developer
1 week ago
Innova Solutions Kennesaw, United StatesInnova Solutions is immediately hiring for an TIBCO Developer. · Job Title: TIBCO Developer · Location: Kennesaw, GA (Hybrid) · Contract Duration: 12+ Months (W2 candidate only) · As an TIBCO Developer, you will: · Job Description: · Design, build and configure applica ...
Sr. Data Warehouse Analyst - Kennesaw, United States - Insight Global
Description
Insight Global is assisting a client with finding a Data Warehouse Developer for a contract to hire opportunity north of Atlanta, GA.
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.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day.
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:.
Required Skills & Experience
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching.
Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.