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: <<SummaryQuality Assurance - Analyst9+ years Tandem based testing/implementation exposure. Talented in
analysis, issue resolving and testing new application in HP Nonstop (Tandem).
SkillsSoftware Skills - 
  
  
  BASIC Programming knowledge
  of C,PATHWAY.Platform & Operating system - 
  
  
  Nonstop Tandem Guardian OS, WINDOWS 2000,XP.Tandem Tools - 
  
  
  EMS, INSPECT,PERUSE, FUP.Message format - 
  
  
  ISO 8583.Switch -      BASE24 6.0.10, EPOC.
ExperienceDelv.Senior Software Engineer.,11/2011to04/2014Illumio–Dallas,TX,Handled
important functions as:Migration of BASE24 6.0.2 to 6.0.10 at Bank of Baroda
client location.Prognosis installation on Tandem server and GUI on
Windows system.Completed MASTERCARD certification successfully at BOB.Handled many other projects after migration.1) Project: NEFT (NATIONAL ELECTRONIC FUND TRANSFER) THROUGH ATM.Client: Bank of Baroda.Role: Compilation /Testing/ Implementation.Team Size: 1.Description:  Configured NEFT through ATM transaction module.2) Project:
PREPAID INTERFACE.Client: Bank of Baroda.Role: Testing/ Implementation.Team Size: 1.Description: 

New flow added in configuration files for different
prepaid bins for NCR and DIEBOLD machines.3) Project:
PETROL/RAILWAY/IRCTC SURCHARGE.Client: Bank of Baroda.Role: Compilation/ Testing/ Implementation.Team
Size: 1Description: Surcharge applied merchant code wise.4) Project:
PIN CHANGE AND MINISTATEMENT CHARGES.Client: Bank of Baroda.Role: Compilation/ Testing/
Implementation.Team Size: 1.Description:Surcharge applied after 5 not on us transaction.5) Project:
RUPAY POS CERTIFICATION.Client: Bank of Baroda.Role: Compilation/ Testing/ Implementation.Team Size: 1.Description: Implemented RUPAY pos transaction.6) Project:
DOMESTIC MASTERCARD EMV CERTIFICATION.Client: Bank of Baroda.Role: Compilation/ Testing/
Implementation.Team Size: 1
.Description: Implemented Domestic EMV MasterCard.7) Project:
DOMESTIC VISA EMV CERTIFICATION.Client: Bank of Baroda.Role: Compilation/ Testing/ Implementation.Team Size: 1.Description: Implemented Domestic VISA MasterCard.8) Project:
RUPAY POS & ATM EMV CERTIFICATION.Client: Bank of Baroda.Role: Compilation/ Testing/ Implementation.Team Size: 1.Description: Implemented Rupay EMV card.9) Project:
MAESTRO CARD CERTIFICATION FOR BOB PG WITH MASTERCARD.Client: Bank of Baroda.Role: Compilation/ Testing/ Implementation.Team Size: 1.Description: Certification of IPG with mastercard for Maestro bin.​Systems Engineer,06/2011to11/2011Tata Consultancy Services Ltd–City,STATE,Handled
important functions as:Migration of BASE24 6.0.2 to 6.0.10
.Installing ASSET application an ACI product.Atm and Pos testing on UAT before migration.Base24 configuration Analysis and Database Maintenance.Sr. Technical Associate,04/2008to06/2011FSS Pvt Ltd–City,STATE,Handled important functions as:Performed System Analysis and Database
Maintenance,

     Disk Analysis and Load Sharing.Base24 configuration Analysis and Database
Maintenance.Creating New Macros and Programs for various switch
Activities TACL, Enform.Configuration of ATM’s.Configuring and Downloads to ATM.Using of FUP
(File Utility Program).Using of Enform & Macros Application on the ENSCRIBE database.Monitoring Stations and various Processes using
Prognosis.
Education and TrainingBachelor of Science:Information Technology,Expected in2008toPd.Dr.V.V.Patil College of Engineering and Technology.-Loni,MaharashtraGPA:DIPLOMA: Passed
with Second Class in Information Technology, Pd.Dr.V.V.Patil College
of Engineering and Technology in Feb 2008 affiliated to the Maharashtra State Board of Technical Education.High School Diploma:Science,Expected in2002toR.K.Talreja College of Arts, Commerce & Science-Ulhasnagar,MaharashtraGPA:H.S.C. :  R.K.Talreja
College of Arts, Commerce & Science affiliated to the Maharashtra State
Board Of Secondary & Higher Secondary Education in March 2002 with 48.50%.Secondary School Certificate.:,Expected in2000toP.M.M Inner wheel School-Ambernath,MaharashtraGPA:S.S.C. :  P.M.M
Inner wheel School, affiliated to the Maharashtra State Board of Secondary
& Higher Secondary Education in March 2000 with 62.53%.
SkillsSkills with respect to Payments Switching:Good Experience in Base24 & EPOC ATM & POS
products.Good in Configuration management of BASE24 & EPOC
data files.Sound knowledge in Messaging standards.Strong Problem Solving Skills, Flexible and adaptable in new environments.Experience in Testing Methodologies.Good experience in certifications, source code
compiling.>>. The result is, Good Fit

Fit assessment: Good Fit