Data Warehouse Analyst at Jobot
Kennesaw, GA 30144
About the Job
Data Warehouse Analyst needed business consulting firm in northwest Atlanta! Hybrid
This Jobot Job is hosted by: Mike Williams
Are you a fit? Easy Apply now by clicking the "Quick Apply" button
and sending us your resume.
Salary: $75 - $80 per hour
A bit about us:
At our organization, we understand that our success stems directly from our dedicated workforce. Each member of our team brings unique skills and perspectives, contributing to our collective growth and success. We offer competitive salaries and benefits, prioritize work-life balance, and provide numerous opportunities for professional development. It's no wonder we've consistently been recognized as one of the "Best Places to Work in Insurance" by Business Insurance. Explore the opportunities we offer to support your personal and professional advancement.
Why join us?
Job Details
Responsibilities:
Foster and maintain relationships with end users to optimize existing reports and integrations, catering to their needs.
Enhance ETL processes by coding for database access, modifications, and construction, including stored procedures and ETL packages, to integrate new or existing data sources.
Develop and customize SSIS Packages utilizing C# scripting language as necessary.
Design and modify SSRS Reports.
Identify logical and physical architecture requirements for integrating new or existing sources into an Enterprise Business Intelligence system.
Develop logical and physical models for new databases or modifications to existing ones.
Evaluate, test, implement, and maintain company databases to meet Business Intelligence Architecture and Data Integration needs.
Install and configure software components to ensure the smooth operation of Business Intelligence Architecture and Data Integration processes.
Establish standards for installation, operational support, and information security in alignment with corporate IT standards.
Implement Change Data Capture software for monitoring transaction data from source systems.
Integrate new data with existing warehouse structure and continually enhance system functionality.
Deliver Business Intelligence Solutions using Microsoft technologies like SharePoint, Excel, Analysis Services, Reporting Services, etc.
Qualifications:
Bachelor's Degree in Computer Science, related field, or equivalent education/experience.
Minimum of 8 years of relevant and progressive professional experience.
Stay updated on industry changes, legal updates, and technical developments.
Proficiency in SQL, including Microsoft SQL Server 2012 or above, Transact-SQL, and Business Intelligence Development Studio (SSAS, SSIS, SSRS, Visual Studio).
Strong background in data analysis.
Preferred experience with Power BI.
Familiarity with MDX.
Operational Data Warehouse experience.
Interested in hearing more? Easy Apply now by clicking the "Quick Apply" button.
This Jobot Job is hosted by: Mike Williams
Are you a fit? Easy Apply now by clicking the "Quick Apply" button
and sending us your resume.
Salary: $75 - $80 per hour
A bit about us:
At our organization, we understand that our success stems directly from our dedicated workforce. Each member of our team brings unique skills and perspectives, contributing to our collective growth and success. We offer competitive salaries and benefits, prioritize work-life balance, and provide numerous opportunities for professional development. It's no wonder we've consistently been recognized as one of the "Best Places to Work in Insurance" by Business Insurance. Explore the opportunities we offer to support your personal and professional advancement.
Why join us?
- Competitive base salary and overall compensation package
- 401 K with generous company match
- Full benefits: Medical, Dental, Vision
- Generous PTO, vacation, sick, and holiday schedule
- Life Insurance coverage
Job Details
Responsibilities:
Foster and maintain relationships with end users to optimize existing reports and integrations, catering to their needs.
Enhance ETL processes by coding for database access, modifications, and construction, including stored procedures and ETL packages, to integrate new or existing data sources.
Develop and customize SSIS Packages utilizing C# scripting language as necessary.
Design and modify SSRS Reports.
Identify logical and physical architecture requirements for integrating new or existing sources into an Enterprise Business Intelligence system.
Develop logical and physical models for new databases or modifications to existing ones.
Evaluate, test, implement, and maintain company databases to meet Business Intelligence Architecture and Data Integration needs.
Install and configure software components to ensure the smooth operation of Business Intelligence Architecture and Data Integration processes.
Establish standards for installation, operational support, and information security in alignment with corporate IT standards.
Implement Change Data Capture software for monitoring transaction data from source systems.
Integrate new data with existing warehouse structure and continually enhance system functionality.
Deliver Business Intelligence Solutions using Microsoft technologies like SharePoint, Excel, Analysis Services, Reporting Services, etc.
Qualifications:
Bachelor's Degree in Computer Science, related field, or equivalent education/experience.
Minimum of 8 years of relevant and progressive professional experience.
Stay updated on industry changes, legal updates, and technical developments.
Proficiency in SQL, including Microsoft SQL Server 2012 or above, Transact-SQL, and Business Intelligence Development Studio (SSAS, SSIS, SSRS, Visual Studio).
Strong background in data analysis.
Preferred experience with Power BI.
Familiarity with MDX.
Operational Data Warehouse experience.
Interested in hearing more? Easy Apply now by clicking the "Quick Apply" button.
Salary
75 - 80 /year