Job description:
the senior manager, data architecture & data engineering is responsible for translating business strategic goals into future-state data engineering and data science solutions. this includes delivery full life-cycle from execution roadmaps, to implementation, and to production operations. this role drives the creation and maintenance of enterprise data and analytics capabilities, data reference architectures, and integrated data & analytics technology roadmaps that will guide our strategic investments and enterprise strategy.translate business strategic goals into actionable future-state data engineering and data science architectures and solutions.delivery of full life-cycle data solutions from execution roadmaps, to implementation, and to operations. this includes a specific focus on elt and etl data pipeline solutions from inception to production.lead end to end solution delivery of enterprise data warehouse, data marts, and data lake with governance.drive the creation and maintenance of enterprise data and analytics capabilities, data solutions, and integrated data & analytics technology roadmaps that will guide our strategic investments and enterprise strategy.deliver architecture connecting data science, data engineering, and data analytics practices together to deliver impactful data products.strong partnership with devops, dataops, business partners, engineering teams, and data management.a minimum of ten (10) years of experience in it with a minimum (6) years in data architecture and data solutions are required.successful track-record in managing a team of data engineers and data scientistsskilled in hybrid cloud data platforms and analytical technologies including azure andor gcp data infrastructure, spark, data lake, data warehouse and data marts, bi reporting with powerbi, metadata management, data governance, master data management, data catalog, and business glossary.ability to document, communicate, implement, and operationalize complex architectures.experience with elt and etl data pipeline solutions from inception to production.proficient in sql, nosql and columnar databases.experience with sparkpyspark and json.excellent grasp of computer science fundamentals - data structures and algorithms.must have panda data frames knowledge and best practices, execution engines, dags (airflow, dagster, luigi, etc), and kubernetes.proficient with gitlabfamiliarity with azure data factory preferred, google data flow or aws glueexperience with biomedical informatics, s3azure blob store, machine learning and ai, unstructured data, and data democratization is preferred.experience with agile methodologies, kanban preferred, and using tools like jira and confluence to facilitate the work.bachelor's degree in computer science or a related discipline required. master's degree preferred. recruiters notes: the role will definitely be hands-on and will require excellent communication skills. the hiring manager mentioned the following technologies: aimachine learning; data warehouses; product support; cloud experienceazure; must be open to new technologies. working with the product development team. act as the point of contact; will create a group that helps the product teams. create data warehouses for analytics. must have excellent communication skills verbal and written. this person will envision strategy and must be able to effectively communicate that strategy to others. the organization has asked me not to advertise the compensation. if you contact me i would be more than willing to share it with you. for over 50 years this non-profit organization has made it their mission to protect patients from unsafe and ineffective medical technologies and practices. more than 5,000 healthcare institutions and systems worldwide including four out of every five u.s. hospitals rely on the services of this organization to guide their operational and strategic decisions. in addition, they serve public and private payers, federal and state agencies, policymakers, ministries of health, associations, and accrediting agencies. benefit from a healthy work-life balance while staying on the leading edge of technology and thriving in an innovative startup-like culture minus the risk. sleep well knowing you are helping achieve a world where safe, high-quality healthcare is accessible to everyone. excellent benefits to include work from home, flex-time and 19 days starting vacation. its a nice place to work!

Resume:
<<summary7+ years of experience as a bi developer with a proven track record in business intelligence (bi), data warehouse (dwh) and data analytics related consulting projects.proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.experience d in developing, implementing, documenting, monitoring and maintaining the data warehouse extracts, transformations and etl process in various industries like financial, health care and retail industry withsales, marketing, inventory management, supply chain and financedomains.delivered bi reporting solutions in power bi, reporting services (ssrs).expertise indata warehousing architecturesincludingetldesign,staging,transformations,delta/change datacapture,star-schemas, cubes andhistoryloadingskilled in writingt-sql queries, dynamic-queries, sub-queries and joins for generatingstored procedures, triggers, user-defined functions, views and cursors.experience with all phases of software development life cycle (sdlc) and agile methodologies.have delivered as a team member, team lead and as an independent consultant on medium to large scale projects. skills data/business/systemstools: ms sql server integration(ssis), analysis services(ssas), metldatabases: sql server 2012/2016,netezza 7.2, oracle 11g, azuredevelopment skills: t-sql, dax, mdx, c#bi reporting tools: power bi, reporting services services (ssrs).data quality and standardsagile methodologyprogramming languages:t-sql, c#, vb scripting. education gmr institute of technologyrajam, india,expected in 05/2013––bachelor of science:information technology-gpa: experience honeywell-sr. data analyst/ , 05/2020-currentclient:citi bank, irving, txworking as level2 support engineer for data pipelines the retail customer applications and azure data staging.analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.developing and supporting devops repos and code pipelines for all etls tasks and jobsdevelopedstandardetlintegrationsto extract community-loan-location data from mainframes system and implemented business rules to confirm the data.experience in creating and managing ssas tabular models, creating dimension and fact tables.responsible for data administration tasksmaintenance plans,performance tuning,backup, and securityfor ms sql server systems.primarily involved in data migration using sql azure storage, and azure data factory, ssis, powershell.integrated custom visuals based on business requirements using power bi desktop.developed complex sql queries using stored procedures, common table expressions (ctes), temporary table to support power bi and ssrs reports.developed complex calculated measures using data analysis expression language (dax).embedded power bi reports on the salesforce portal page and also managed access of reports and data for individual users using roles.provided continued maintenance and development of bug fixes for the existing and new power bi reports.butler technical group-sr. , 08/2018- 05/2020led the development of data mart for supply chain,marketing departments along with analysis of existing data warehouse for performance improvements.worked on all phases of data warehouse development life cycle, from gathering requirements, implementation, testing, training and support.interviewed business users of the data warehouse and the business analysts to understand and troubleshoot the existing bottlenecks and problem areas.developed applications and designed processes for transformation and data management from company-wide databases.developed automated data dictionary for enterprise data warehouse using ssrs and sql.completed a thorough analysis of the issues with the cube processing and query processing to identify bottleneck for the existing facts and dimensions.designed and developed etl packages to facilitate incremental load process.created aggregates, partitions, attribute relationships and user defined hierarchies with the goal to reduce the cube processing time and query processing time.created stored procedures and performed index analysis for slow performing ssrs reports to bring down the report rendering time.developed enterprise wide cascading reports in ssrs that were used throughout the agency to monitor the performance of the cube, logging of the nightly etl loads and also to monitor most active users of the cube.created robust and high-performing etl mappings usingssisandmetl.migrated existing self-service reports and adhoc reports to power bi.developed custom calculated measures using dax in power bi to satisfy business needs.assisted users in accessing databases, troubleshooting malfunctions and removing system-based barriers to task completion.kairos technologies inc-sr. etl developercity,state, 11/2016- 07/2018client:cvs caremark, irving, txworked on ambitious project to develop an enterprise wide drug plan record system data warehouse connecting insurance companies and drug manufacturers for cvs caremark.worked with business intelligence manager to plan bi strategies, create bi road map and budget plans to deliver on organizations business intelligence needs.assessed the impact of current business processes on users and stakeholders.developed multiple dashboards, analytical reports, kpis and interactive reports based on business requirements using ssrs to support executive business needs.transferred data from various data sources/ access, flat files,cosmos etc. to sql server using ssis.implemented query optimization and performance tuning for slow performing sql queries.involved in writing complex t-sql queries and stored procedures to perform data transformations and to support ssrs reports.involved in creating user security and roles in reporting services at both parent level and report level.supported maintenance of data quality service's (dqs) knowledge base and development of master data service's database.tata consultancy services-business data analystcity,state, 07/2013- 04/2016client:sun trust bank, usdesigned, implemented, and aided end-to-end data migration project using microsoft ssis.assisted in creation of internal applications for marketing and customer relations departments, including financial reporting tools and reports.designed ssis packages to extract data from various data sources such as excel spreadsheet, and flat files and load data into destination databases for further data analysis and reporting.performed rigorous business case analyses and proposed various process improvements.used excel and access applications for visualizing the data functionality.led an initiative to convert all excel files which were used in in-house time/expense reporting wherein i automated the process to find discrepancies in timesheets by creating tables, views using stored procedures.client :marks and spencer,ukimproved business direction by prioritizing customers and implementing changes based on collected feedback.analyzed open orders, backlog, and sales data to provide sales team with insights.created tables and define their relations by using foreign key and primary key relationship.involved in creating database objects using stored procedures, triggers, functions, views and t-sql joins using t-sql.performed normalization of database to reduce redundancy and achieve maximum system performance.wrote custom t-sql stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionalityworked as etl developer for an end-to-end implementation of operation data warehousing project.responsible for data integration and transformation using ssis.formulated and documented the physical etl process design based on business requirements and system specifications with strong etl design skills.created source to target mappings, transformations, lookups, aggregations, expressionsinvolved in scheduling reports, creating snapshot reports and subscription for the reports using ssrs.