company

Senior Data Warehouse Developer

Mavens-guildChicago, IL
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Senior

Qualifications

Design and develop ETL and reporting processes using SSIS/SSRS tools adhering to 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, optimize 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 business users and external vendors. Collaborate with management to prioritize business and information needs. Discover and evaluate new process improvement opportunities. The successful candidate will have at least 8 years of experience as a data warehouse developer or ETL specialist, demonstrating a deep understanding of relational databases and solid experience working with data models, database design, and performance tuning techniques. Experience with voluminous databases, creating database objects, and optimizing complex SQL queries for performance is essential. Familiarity with ETL and reporting tools such as SSIS, SSRS, SSAS, Informatica, and Business Objects is required. Strong analytical thinking skills are vital for success in this role, as you will be expected to comprehend the business context before applying your technical expertise. Additionally, you should be adept at collecting, organizing, analyzing, and disseminating significant amounts of information with meticulous attention to detail and accuracy. Knowledge of documentation and code versioning is advantageous, along with experience using enterprise automation tools. A BS degree in Computer Science or relevant experience may substitute for formal education in exceptional cases. Complementary skills in Java programming, Python, or experience with other databases such as Oracle, Netezza, MongoDB, or Teradata will be considered a significant advantage.

About the job

We are looking for a highly skilled Senior Data Warehouse Developer to join our team at Mavens-guild in Chicago, IL. The ideal candidate will play a pivotal role in acquiring, curating, and modeling various transactional data, transforming it into actionable insights that drive informed business decisions. You will oversee the complete development lifecycle, which includes requirements gathering, analysis, development, testing, and production deployment. Your expertise will be essential in managing daily data warehouse operations utilizing SSIS, SSRS, SSAS, and optimizing MS SQL Server performance.

We seek an analytical thinker with a creative approach to problem-solving, showcasing a robust experience with the entire Microsoft BI stack. A solid understanding of SQL Server and advanced SQL tuning techniques is crucial for this role.

About Mavens-guild

Mavens-guild is a forward-thinking organization dedicated to leveraging data for strategic decision-making. We foster a collaborative environment where talented individuals can thrive and contribute to innovative solutions. Join us in our mission to transform data into powerful insights.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.