Launch Your Career with Cook SystemsnnReady 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.nnOur 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.nnJoin 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!nnTwo job openings but only 2 Submittals - Both In Person and on site interview nLocal Richmond, VA candidates ONLY required due to onsite requirementn**This position requires onsite 3 days a week with 2 remoten**Contractor will be responsible for purchasing parking through VDOT?s Parking Management Office or procuring their own parkingnnnJob Description: SR ETL DevelopernThe Virginia Department of Transportation (VDOT)Information Technology Division (ITD) is seeking a Master Data Analyst with demonstrated experience in data analytics to work as a key member of Enterprise Data Asset team. This analyst will support teams working in Agile (Sprint) to analyze datasets to be made available in a cloud-based data management platform that will support the agency to produce master data with data governance.nResponsibilities include analyzing source systems which contain a spatial component for candidate datasets; documenting business processes and data lifecycle; developing data requirements, user stories and acceptance criteria; and testing strategies. Develop ETL to extract business data and spatial data and load it into a data warehousing environment. Design and test the performance of the system. Consult with various teams to understand the company?s data storage needs and develop data warehousing options. Deep knowledge of coding languages, such as python, Java, XML, and SQL. Well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.nnVDOT is a fast-paced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects, and remain flexible and productive, despite changing priorities and processes. Ongoing improvement and efficiency are a part of our culture, and each team member is expected to proactively contribute to process improvements.nnnResponsibilities:nn? Work with the Project team members and business stakeholders to understand business processes and pain pointsn? Develop expertise in source system datasets and data lifecyclen? Profile source data which may contain a spatial component; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolutionn? Conduct entity resolution to identify matching and merging and semantic conflictsn? Elicit, record, and manage metadatan? Diagram current processes and proposed modifications using process flows, context diagrams and data flow diagramsn? Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staffn? Utilize progressive elaboration; map stories to data models and architectures to be used by internal staff to facilitate master data managementn? Identify and group related user stories into themes, document dependencies and associated business processesnnDiscover and document requirements and user stories with a focus on improving both business and technical processingn? Assist Product Owner in maintaining the product backlogn? Create conceptual prototypes and mock-upsn? Collaborate with staff, vendors, consultants, and contractors as they are engaged on tasks to formulate, detail and test potential and implemented solutionsn? Perform Quality Analyst functions such as defining test objectives, test plans and test cases, and executing test casesn? Coordinate and Facilitate User Acceptance Testing with Business and ensure Project Managers/Scrum Masters are informed of the progressnn?Designs and develops systems for the maintenance of the Data Asset Program(Data Hub), ETL processes, ETL processes for spatial data, and business intelligence.nn?Develop a new data engineering process that leverage a new cloud architecture and will extend or migrate our existing data pipelines to this architecture as needed.nn?Design and supports the DW database and table schemas for new and existent data sources for the data hub and warehouse. Design and development of Data Marts.nn?Work closely with data analysts, data scientists, and other data consumers within the business in an attempt together and populate data hub and data warehouse table structure, which is optimized for reporting.nn?The Data developers partners with Data modeler and Data architect in an attempt to refine the business?s data requirements, which must be met for building and maintaining Data Assets.nn?nnQualificationsnnRequired:nThe candidate must have a minimum of 10 years of experience delivering business data analysis artifactsnn5+ years of experience as an Agile Business Analyst; strong understanding of Scrum concepts and methodologynnExperience organizing and maintaining Product and Sprint backlogsnnExperience translating client and product strategy requirements into dataset requirements and user storiesnnProficient with defining acceptance criteria and managing acceptance processnn?Exceptional experience writing complex sql queries for Sql Server and Oraclenn?Experience with Azure Databricks, Azure data factory, snowflakenn?Experience with ESRI ArcGISnnExperience with enterprise data managementnnExpertise with Microsoft Office products (Word, Excel, Access, Outlook, Visio, PowerPoint, Project Server)nnExperience with reporting systems ? operational data stores, data warehouses, data lakes, data martsnn?The candidate must have exceptional written and oral communications skills and have the proven ability to work well with a diverse set of peers and customersnnnnPreferred Skills:nn? Advanced understanding of data integrations.nn?Strong knowledge of database architecturesnn?Strong analytical and problem solving skillsnn?Ability to build strong relationships both internally and externallynn?Ability to negotiate and resolve conflictsnn?Ability to effectively prioritize and handle multiple tasks and projectsnn?Strong written and verbal communication skillsnn?Desire to learn, innovate and evolve technologynnComputer Skills/MS Office/Software:nn?Excellent computer skills and be highly proficient in the use of MS Word, PowerPoint, MS Excel, MS Project, MS Visio, and MS Team Foundation Server, which will all be necessary in the creation of visually and verbally engaging ETL, data designs and tables as well as the communication of documentation and reporting.nn?Deep passion for data analytics technologies as well as analytical and dimensional modeling. The candidate must be extensively familiar with ETL(Extraction, Transformation & Load), data warehousing, and business intelligence tools such as business objects, PowerBI and Tableau.nn?The candidate must also have vast knowledge of database design and modeling in the context of data warehousing.nn?Experience with key data warehousing architectures including Kimball and Inmon, and has a broad experience designing solutions using a broad set of data stores (e.g., HDFS, Azure Data Lake Store, Azure Blob Storage, Azure SQL Data Warehouse, Azure Cosmos DBnnTechnologies Required:nn?Data Factory v2,Data Lake Store, Data Lake Analytics, Azure Analysis Services, AZURE Synapsenn?IBM Datastage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse.nn?Operating System Environments (Windows, Unix, etc.).nn?Scripting experience with Windows and/or Python, Linux Shell scriptingnDesigns and develops systems for the maintenance of the Data Asset Program, ETL processes, and business intelligence.nRequiredn10nYearsnDesign and supports the DW database and table schemas for new and existent data sources for the data hub and warehouse. Design and development of DatanRequiredn10nYearsnWork closely with data analysts, data scientists, and other data consumers within the business in an attempt to gather and populate data hub and datanRequiredn10nYearsnAdvanced understanding of data integrations.? Strong knowledge of database architectures, strong understanding of ingesting spatial datanRequiredn10nYearsnAbility to negotiate and resolve conflicts,? Ability to effectively prioritize and handle multiple tasks and projectsnRequiredn10nYearsnExcellent computer skills and be highly proficient in the use of Ms Word, PowerPoint, Ms Excel, MS Project, MS Visio, and MS Team Foundation ServernRequiredn10nYearsnExperience with key data warehousing architectures including Kimball and Inmon, and has a broad experience designing solutions using a broad set of danRequiredn10nYearsnexpertise in Data Factory v2,Data Lake Store, Data Lake Analytics, Azure Analysis Services, Azure SynapsenRequiredn10nYearsnIBM Datastage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse.nRequiredn10nYearsnOperating System Environments (Windows, Unix, etc.).? Scripting experience with Windows and/or Python, Linux Shell scriptingnRequiredn10nYearsnExperience in AZURE Cloud engineeringnRequiredn10nYearsnnWhy Work with UsnnBenefitsnnAt 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:nn 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.n 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.n 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.n Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.n 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.nnAt 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. Responsibilities: Analyze datasets for master data management
Develop ETL processes and data warehousing solutions
Collaborate with stakeholders to gather and refine data requirements
Conduct entity resolution and manage metadata
Perform Quality Analyst functions and facilitate User Acceptance Testing