Ideal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.
We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.
Design and develop ETL and reporting processes using SSIS/SSRS tools based on 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, fine tune 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 consumption by business users and external vendors
Collaborate with management to prioritize business and information needs
Find and evaluate new process improvement opportunities
8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniques
Solid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performance
Solid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business Objects
Strong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skills
Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Good knowledge of documentation and code versioning
Good knowledge of working with enterprise automation tools
BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates
Complimentary skills sets like background in Java programming, Python and/or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus!
Senior Data Warehouse Developer • Chicago, Illinois, United States
Federal Reserve Bank of Atlanta.Federal Reserve Financial Services (FRFS) delivers a suite of payments services to financial institutions via FedLine® Solutions, Fedwire® Funds and Securities, the ...Show more
Hybrid Chicago - IL (3 days a week in office).Required Skills - IBM Infosphere Datastage.Nice to have skills - Python,Datastage Admin.Senior ETL Datastage developer with 10+ years of experience to ...Show more
Senior Database Developer Astor & Sanders Corporation (Astor) is an award-winning IT solutions provider headquartered in McLean, VA seeking a Senior Database Developer with Appian experience.This i...Show more
At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things ! We enable our clients to achieve key business outcomes that reshape how ...Show more
Join the Market Leader in Electric Power Data and Analytics Solutions.The electrical grid is the largest and most complex machine ever constructed.Ripple Effect Consulting’s industry-leading electr...Show more
Essential Duties and Responsibilities:.Establish and maintain enterprise data warehouse (EDW) architecture environments and data ingestion/integration development frameworks, including architecting...Show more
Kenexai delivers smart, data-driven solutions that empower businesses across industries.Our mission is to combine deep, domain-specific expertise with cutting-edge technology to drive meaningful im...Show more
About the Company We are one of the world's largest and most prestigious full-service law firms, with a global footprint spanning more than 20 offices across the Americas, Europe, and Asia Pacific....Show more
We're determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies.Working here means having every opportunity to achieve your goals - and t...Show more
Above Lending is a next-generation financial services company.We provide simple and transparent products aimed at helping our clients achieve their personal finance goals.With competitive rates and...Show more
The Epsilon Activation Delivery Platform team builds the core framework and connectors powering our audience activation business.We are a small, high-impact team of engineers operating at massive s...Show more
As a Senior Data Architect, you will design and evolve Hightower’s enterprise data ecosystem, leading initiatives in data modeling, Master Data Management (MDM), and data standards development.You ...Show more
Federal Reserve Bank of Atlanta.Federal Reserve Financial Services (FRFS) delivers a suite of payments services to financial institutions via FedLine® Solutions, Fedwire® Funds and Securities, the ...Show more
We are seeking a highly motivated Senior SQL Developer with strong technical and analytical skills.Experience in property and casualty (P&C) insurance is preferred.This role involves system analysi...Show more
Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital...Show more
RAPP Chicago is looking for a Senior Data Engineer to join our award-winning Technology team.We are RAPP - world leaders in activating growth with precision and empathy at scale.As a global, next-g...Show more
A leading healthcare institution in Chicago is seeking a Senior Analytics Developer to drive strategy through data analysis and insights.In this role, you will collaborate across various teams to t...Show more
Secure Every Identity, from AI to Human.Identity is the key to unlocking the potential of AI.Okta secures AI by building the trusted, neutral infrastructure that enables organizations to safely emb...Show more
