Programmer/Developer

Launch Your Career with Cook SystemsReady to elevate your career? Cook Systems, a certified veteran owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you're aiming to work with a Fortune 500 company or a small business, we've got you covered.Our core values: integrity, investment, and innovation drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work life balance and personal growth. Our cutting edge IT consulting partners and FastTrack talent program are designed to help you excel.Join our forward thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins.2 Submittals - Local Candidate Monday-Friday 8 hour days - Hybrid Market-rate compensation packageJob Summary and Responsibilities:Under the supervision of the strategic data management & solutions team, the developer is responsible for creating a data system project from raw data collection to the report output tables using Microsoft business intelligence solutions. This requires creating a 3-layer data process, creating an automated data collection using ETL process, data integration layer into the warehouses and building analytical data cubes. The role involves working with the stakeholders to understand the needs, translating them into technical requirements and delivering project outcomes within the timeline.? Create database and schema objects to build the fiscal system from historical files.? Automate the raw data collection from FTP client server sources (CSV, Excel etc.file).? Set up FTP tasks for mail notifications and send mail task packages using SSIS.? Create and automate ETL process using SSIS to load clean data into the system.? Develops, configure and deploy SSIS packages. Implement event handlers and error handling notifications.? Create and connect error reports (BI reporting tools) for the data submitters from the raw data files.? Write complex queries to build joins and data logic for business definitions using T-SQL scripts.? Build data relationships and create Dimension and Fact tables to maintain a consistent final output through calculated fields.? Design/develop/optimize stored procedures for data warehouse tables.? Perform testing, troubleshooting report issues and optimizing query performance.? Build OLAP cubes/DataMart for analytical reporting.Qualifications:? Bachelor?s degree or equivalent education in computer science, math, or related science field required.? 5+ years proficiency in SQL Server/T-SQL language required.? 5+ years proficiency using Microsoft tools (SSIS, SSAS, BI reporting tools) required.? 4+ years? experience as an ETL developer.? 5+ years of experience in business intelligence development area building data warehouses & data marts required.? Work experience in the Fiscal/Finance industry is preferrable.Skills & Strengths:? Latest versions of Microsoft BI technologies (SSIS, SSAS, SSRS, PowerBI)? Data warehousing (star schema, snowflake schema)? Dimensional modeling? ETL processes? Data Analysis & troubleshooting? Analytical ThinkingPosition: 12-month contract or until the project go live. Hybrid position with a need to be in office at least once a week. Hiring TN residents only.Skills Database Data Analysis Proficient (4-6 Years) Yes Skills Database Data Modeling Proficient (4-6 Years) Yes Skills Database Data Warehousing Advanced (7-9 Years) Yes Skills Database Microsoft SQL Server Advanced (7-9 Years) Yes Skills Database Transact-SQL Advanced (7-9 Years) Yes Skills Languages SQL Advanced (7-9 Years) Yes Skills Others Microsoft BI Business Intelligence Development Advanced (7-9 Years) YesEducation Others Bachelors or Masters Computer Science, math, or related science field required. Proficient (4-6 Years) YesSkills Others Team work Advanced (7-9 Years) Yes Skills Tools VisualStudio Proficient (4-6 Years) YesWhy Work with UsBenefitsAt Cook Systems, we don't just offer jobs we build futures. Our team is the heart of everything we do, and we're committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here's what you can look forward to:Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation's largest networks, you'll get the care you need for yourself and your family wherever life takes you.Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.Flexibility for Life's Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.At Cook Systems, you're not just another employee you're family. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let's build the future together at Cook Systems.