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: <<SummaryHaving achieved a milestone of 7+ years of working as a software quality process manager within the financial software industry, I would be a great addition to your product management team as I have extensive experience with coordinating and managing efforts with multiple teams consisting of solution architects, project/program managers, product managers, and production support to name a few. In addition, my experience has taught me flexibility and versatility in developing innovative resolutions to a myriad of complex organizational problems while also dealing directly with clients.
Key SkillsMicrosoft Office SuiteSharePointHP Quality CenterTRACCrystal ReportsSQLFailure Modes Effects Analysis (FMEA)Requirements ManagementSystem-a-tion Business Analysis CertificationCertified HelixPlan Methodology FacilitatorSystem-a-tion Business Requirements CertificationVisual Basic (VB.Net)HTML
ExperienceSoftware Quality Assurance Consultant,03/2010-05/2015Valmet Corporation–Little Rock,AR,QA software process manager on large scale enterprise implementation projects for multiple national/international financial institutionsManaging the development and implementation of cross-company QA process throughout the SDLC including estimation, forecasting, budgeting, requirements review(s), requirements traceability, test schedule, overseeing testing execution, and defect resolution for implementation(s)Process Management- collaborated/coordinated with senior leadership to design end-to-end process methodology that led to an increase in overall estimation and forecast accuracy by more than 12% on project implementationsProcess Development- developed process templates to close gap between client user experience and end customer experience that resulted in identifying additional requirements that would have created a scope gap later on in the SDLCProcess Improvement- integrated QA methodology with the program/project management practice to create software quality standards across client and internal teams within the SDLC that resulted reducing implementation defects by 28% on averageBusiness Analyst,2009-03/2010Metavante–City,STATE,Manage scope and requirements on medium to large scale financial institution projects for enterprise flagship productsDefined requirements by coordinating with solution architect and vendor teams to define testable requirements and scope for implementation projectsRequirements Management- analyzed client business needs to formulate project scope & requirements to efficiently translate to technical and testable requirements while cutting down hours for internal teamsRelationship Management- developed collaborative relationships with product teams to identify appropriate coverage of business requirements while reducing gaps by 5% on all projectsDocument Management- identified necessary documents to fulfill clients' business needs and ensured accuracy and completeness by conducting audits throughout the SDLC to identify gaps early in the SDLC while reducing number of necessary change requests by clients on projectsUser Scenario Development- coordinated user scenarios and screen mock-ups with clients that increased test coverage allowing early detection of defects within the SDLCSoftware Test Analyst Intern,02/2008-2009Metavante–City,STATE,Perform manual testing on small to medium scale implementation projects for internal systems linking directly into client environmentsDeveloped and managed test plans, test cases, test execution, and defect identification/verificationData Analysis- created test execution reports to identify any potential risks to meeting implementation deadlines Test SuiteDevelopment- coordinated testing efforts with business analysts, QA leads, and technical analysts to develop testing suite and increased overall testing efficiency by 5%Defect Management- identified and managed software defects prior to client implementation, resulting in reduced development re-work by 8% Mentoring - trained newly hired interns & full-time employees on product specifications/functionality through presentations that effectively reduced learning curve by 30%
EducationMBA:,Expected in2017--,GPA:Status-Expected to start in Fall 2015Bachelor's:Business Administration,Expected in2008-University of Wisconsin-Milwaukee,WisconsinGPA:Status-Emphasis in finance & marketingPMP Certification                                                                                              In Progress:,Expected in--,GPA:Status-
LanguagesUrdu                                               Hindi                                           English>>. The result is, Potential Fit

Fit assessment: Potential Fit