For the given job description <<General Summary
The Sr Business Systems Database Software Engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. This position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making.
Job Functions
Design, administer and maintain a robust and scalable data warehouse for our Solver-based Corporate Performance Management (CPM) system within the Microsoft Azure cloud environment.Utilize domain knowledge of production tracking tools such as ShotGrid and Ftrack to streamline data collection and analysis processes, feeding into the data warehouse.Manage Azure based SQL databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.Develop and optimize Python APIs to facilitate efficient and secure data access and retrieval from the data warehouse.Collaborate with Accounting and Finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.Build comprehensive and insightful financial and operational reports, leveraging the data warehouse.Create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.Take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.Provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes.
Qualifications
5+ years of professional experience in Computer Science, Information Technology, Finance or a related field as a Database Architect, Database Engineer or similar role.Proficiency in Microsoft Azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.Strong working knowledge of SQL databases, data modeling, and performance optimization techniques.Proven experience developing Python APIs for data retrieval and integration.Demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.Expertise in working with production tracking tools such as ShotGrid and Ftrack.Advanced skills in Microsoft Excel for building financial and operational reports.Excellent problem-solving skills and the ability to navigate complex business and financial requirements.Strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.Self-motivated, detail-oriented and adaptable to changing business needs.A passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies.
Physical Demands and Work Environment
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Physical demands: While performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. The employee must lift andor move up to 15 pounds. Vision abilities include close vision, distance vision, and the ability to adjust focus.Work environment: While performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. The noise level is usually quiet or moderate.
Location
On-site in Hillsboro, OR  and also eligible for hybrid work  Remote Eligible.
Salary
Salary Is Commensurate With Skills And Experience.
Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified.
Please review our EMPLOYMENT DISCLAIMER and MATERIALS SUBMISSION AGREEMENT.>> the resume: <<Professional SummarySeeking Challenging and Rewarding Assignments with a growth Oriented Organization My Role Worked on Hybrid driven framework in WebDriver and Page Object Model. Good knowledge of creating xpath to find dynamic objects. Good knowledge of writing test script using Selenium-WebDriver with TestNG. Experienced in developing test automation scenarios and scripts for Web applications. Experienced in developing Generic Scripts and Project Specific Scripts. Working experience of Apache POI APIs, TestNG, , Jenkins for continuous integration testing Basic knowledge of Selenium IDE. Good understanding and analysis of client requirements and experienced in creating suitable Automation scripts. Exposure to all stages of SDLC & STLC and good understanding of ATLC (Automation Testing Life Cycle).Analyze requirements and conduct requirement clarification session for team
SkillsTest Management Tools :HP ALM 11, Caliber, HP-Quality Centre, CA Central Rally ,JiraDatabase/Language:Oracle 11g (Toad), PL SQLProgramming Language: JAVA , HTMLOperating System:WindowsServer,Windows2016, Windows20012R2, Windows2012R1 ,Windows2008 R2,Linux ,UNIXAutomation tool: Selenium WebDriver, TestNG, Selenium IDE, Jenkins, Maven, SVN ServerDomain:Health and Welfare, TelecommunicationBudgeting and finance
Work HistorySn. QA Software Engineer Tester,08/2016to12/2017Pitney Bowes Softwares–,,Indiahttp://www.pb.com About Project: SPECTRUM is an ETL tool that has several modules such as DI (Data Integration), DQ (Data Quality), SDF (Spectrum Data Federation), UAM(Universal Addressing Module )BDI (Big Data Integration), BDQ (Big Data Quality) etc., which are used to transform data as per need.Spectrum server has different interfaces from where in user can configure different data sources and can apply logical functions over data to transform data in required format and that can be saved, exported to different sources and formats Environment : Windows: Window2008R2 Standalone, Window2012R1Standalone , Window2012R2Standalone , Windows2016SStandalone Linux: Centos 6.3, OELlinux 6.5, Ubuntu14 Unix: AIX6.1,Solaris11 Description of work : As a Sr.Quality Analyst in spectrum worked on various modules like DI, DQ and UAM with following responsibilities: My Role Understanding the business requirements and developed Use cases to test the complete functionality of the application.Written batch scripts, shell scripts, basic java classes and worked on CI tool Jenkins Perform Functional, Integration and System testing.Writing test cases.Reporting and Tracking of bugs in JIRA.Verifying the bug fixed.Software Engineer Tester,11/2014to08/2016Century Link–,,IndiaAbout Project: Ensemble is a pure telecom project; it is used by the customer service representatives and deals with providing various products to customers as per their request like new High speed connections, Prism connections, changes in customer plans and so forth.The projects involves System Testing, Regression Testing, Sanity Testing and development of an automated test setup for testing, design & development of software for automating the regression test cases Environment : Java, Windows XP Description of work : Analyzing the requirements, testing the functionality and workflow of the application.Software engineer(Testing),10/2012to11/2014Xerox–City,STATE,About Project:XEROX benefits website is prepared for its employees to provide them an opportunity to enroll in their US Health and Welfare benefits through the web. Most of the stuff which the end users see on the web is driven by the complex eligibility logic. Some of the action which end user can take on the web are as follows:•	Making elections during window period of Annual Enrollment or Qualified Life events.•	Report a life event.•	Add and Remove Dependents and Beneficiaries.•	Add and Update personal information.BA7/A.I.S. (Account Inquiry system) is a tool used by Customer Support Representative. Users can call Customer Support Representative and select all the eligible Health and Welfare benefits and update personal information also.My Role	Test planning: Creation of Test Plan Document for various modules of the H&W system (BA7 System), based on the Business Requirement Document.	Executing the test cases: Performing the integration testing of the BA7 system to check the functionality of the application developed. Actively helped to test the participant on Web.	Test management: Log the defects in the QC and track the progress till it gets resolved.	Web Based Testing: Have undertaken web based testing which includes performing Functionality, Database testing-checking the links, forms, validation in forms and navigation. Have also undertaken performance testing(Load, stress testing) for web applications as well as testing for security issues on web platforms	Regression Testing: Creating regression scenarios and performing regression testing as and when there are updates to the application.	Reporting: Create Defect and Test run report for owned module on project in QC .	Meeting all the target goals & deadlines in Service Delivery while adhering to Service Level Agreements (SLA).	Logs verification through UNIX and Shell scripting	Good experience in UAT
EducationAssociate of Science:IT,Expected in2012toGlobal Institute of Technology-Jaipur,RJGPA:
SkillsAIX6.1, Analyst, A.I., Automation, basic, benefits, Big Data, com, CA, Client, customer service, Customer Support, Data Integration, Database, Delivery, English, ETL, forms, forth, Functional, GUI, HP, Hindi, HTML, http, IDE, Information Technology, Java, Linux, logic, Windows, Window, Windows XP, navigation, Oct, Operating System, Oracle, DB, PL SQL, Prism, Programming, progress, Quality, Reporting, Requirement, scripts, shell scripts, Service Level Agreements, SLA, SOAP, Software engineer, Solaris, tables, Telecommunication, telecom, Toad, UNIX, UNIX and Shell scripting, validation, web applications, website, workflow, Written>>. The result is, Good Fit

Fit assessment: Good Fit