Job description:
title: sr. data engineerlocation: austin, txduration: 6 monthspay rate: $65hr - $70hr on w2 requirements:bachelors degree in computer science or related field plus 4+ years of relevant work experience or a master's degree plus 2+ years of relevant work experience or a phd plus 0-1 years of relevant experiencein lieu of a degree, qualified candidates would require 8+ years of relevant professional experienceexcellent with sqlexcellent programming skills in python and ideally demonstrating an aptitude via experience with multiple languagesexcellent understanding of patterns for data ingest into data warehouse, ingest, cleansing, standardizing, etc., in addition to different data structures like normalized, denormalized, starexcellent experience supporting snowflake data warehouse, including snowpipe (including streams), tasks, transformations, views, dynamic tables. this should include advanced skills in ensuring efficient utilization of snowflake compute and the ability to optimize workloads and warehousebroad experience with cloud paas capabilities, ideally aws cloudwatch, lambda, step functions, snssqs, dynamodb, etc.experience utilizing reporting and data insights toolsexperience in supporting analytics teams data needs, in addition to customer and business reporting. what you'll be doing:provides data engineering support for areas such as finance, sales, business intelligence, product development andor other business usersworks with data consumers and project managers to determine logical and physical database designs for analytics modelscreates and maintains optimal data pipeline architecturesensures architectures are aligned with and support business requirements;ensures that required data is available, can be trusted and is readily accessible by those who need itinfluences the data infrastructure roadmapidentifies, designs and implements internal data management process improvementsplays a key role in application development projects to evolve the companys database architecture and designworks with internal and external data providers on data validation, providing feedback and making customized changes to data feeds and data mappings for analytical and operational useautomates manual processes, transforming them into repeatable capabilitiesworks with fellow team members to ensure design, development and execution align with and support adjacencies and adhere to established architectural standards. top 5 must haves:excellent with sqlexcellent programming skills in python and ideally demonstrating an aptitude via experience with multiple languagesexcellent understanding of patterns for data ingest into data warehouse, ingest, cleansing, standardizing, etc., in addition to different data structures like normalized, denormalized, star;excellent experience supporting snowflake data warehouse, including snowpipe (including streams), tasks, transformations, views, dynamic tables. this should include advanced skills in ensuring efficient utilization of snowflake compute and the ability to optimize workloads and warehousebroad experience with cloud paas capabilities, ideally aws cloudwatch, lambda, step functions, snssqs, dynamodb, etc.

Resume:
<<summarysenior-level accountant ~ analysis/reporting ~ fund accounting ~ global team leadership highly-accomplished, solutions-driven leader and visionary senior-level accounting professional with unique combination of project/financial management, process improvement, fund accounting, data collection/analysis, reporting and strategic offshore partnering skills and expertise. highlightscore competencies accounfinancial statement analysistingfinancial management/analysisfinancial statement preparation/glexcel spreadsheetsdata collection/analysisstatutory reportingreconciliationsprocess improvementproject management mutual fund accountingstrategic planningpolicy/procedure developmentresearchsecurities pricingp&l nav calculationsinternational accounting standards/gaap complianceanalytical problem solving technology integrationcommunicationsrelationship-buildingteam building/trainingclient servicesanalytical reasoningbudget forecasting expertisepeoplesoft knowledgecomplex problem solvingeffective time managementstrong organizational skills flexible team playerfinancial statement analysis experience senior accountant, 08/2013-currentacadia healthcare– ,oversee all accounts, ledgers and reporting systems ensuring compliance with appropriate gaa standards and regulatory requirements.support internal control for receipt of revenue, cost and program budgets with actual expendituresconsistently analyze financial data and present financial reports in an accurate and timely manner. monitor progress and business changes and keep senior leadership abreast of the organization financial status.assist hce leadership in the annual budgeting and planning process; administer and review all financial plans and compare to actual results with a view to identify, explain and correct variances as needed.support the cfo/executive vice president in engaging the board's audit and finance committees around issues and trends in financial operating models and delivery.oversee all financial, project/programs, grants accounting; ensuring that expenditures are consistently aligned with grant and program budget throughout the fund period.responsible to gather financial reporting material for government, corporate and foundation grants.manage cash flow forecasting by working in partnership with the program leaders and cfo.track the performance of invested assets in keeping with policies and investment guidelines.responsible for organizing all the necessary documents for year-end audit; as well working closely with auditors.responsible of processing biweekly payroll for four-hundred employees with minimal errors.captured cost savings by reviewing all procedures, including backup, used by accounts payable and identified/corrected discrepancies in accounts. improved relationship with ap to enable working together with an open approach to problems.tightened financial and it controls and mitigated risk by performing internal audits on a quarterly basis, conducting quality assurance reviews and ensuring regulatory compliance.utilized strong technical skills to answer managers' technical questions, including excel inquiries. worked with human resources manager to resolve technical issues regarding payroll.senior accountant, 08/2005- 12/2012acadia healthcare– ,optimized achievement of financial accounting goals by maintaining and reviewing monthly/ well as reconciling components of net book value and income statement between inventory and gl.eliminated accounting errors in financial documents by analyzing discrepant data, identifying issues, correcting errors and communicating corrective actions to offshore partners. verified information in gl and reports.elevated financial and technical performance by implementing efficient processes for analysis of accounting data and reporting. performed asset/income reconciliations and prepared financial statements.enhanced statutory reporting capabilities by creating imis program requiring only account number and date range to obtain supporting information in required cusip format summed up for quarterly/annual (schedule d) reports.reduced time to create reports by more than 75% from days to hours using excel spreadsheet containing formatted information for all accounts, thereby eliminating need for each accountant to format individual account information.took the initiative to teach myself use of the oracle-based investment management information system (imis), including programming and setting up fields for generation of reports, performed on my own time.expanded technical capabilities using excel spreadsheets in the bloomberg terminal to write vlookup formulas across accounts to call information from bloomberg to linked spreadsheets for calculation of accrued interest.increased operational efficiency with time required to verify accrued interest shortened from 1 day to 1 or 2 hours by using excel spreadsheet to provide information for all securities, freeing time for more complex issues.coordinated 3- by developing excel template and collaborating with coworkers and partners to schedule training in preparation for outsourcing.chosen for excellent leadership abilities to build and lead team in producing a detailed manual, improve understanding of statutory reporting. leveraged strengths of team members to complete manual.minimized errors and incorrect filings in statutory reporting through successful use of manual by entire group, including accountants and offshore partners, which outlines procedures for quarterly and annual reports. education bachelor of science:business administration, finance,expected in-manhattan college-riverdale,nygpa:status-manhattan college, bachelor of science in business administration with concentration in finance skills accountant, accounting, excel, accounts to, filings, financial accounting, , inventory, journal, offshore, oracle, reconciliations, reconciling, schedule d, securities, statutory reporting, training, finance, , audit, audits, basis, budget, budgeting, budgets, cash, financial reporting, financial reports, forecasting, human resources, internal audits, payroll, progress, quality assurance, regulatory compliance, client services, collection, data collection, financial management, fund accounting, gaap, integration, integrator, office, mutual fund, peoplesoft, pivot tables, powerpoint, pricing, problem solving, process improvement, project management, quickbooks, solutions, strategic planning, team building, word.