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 ProfileClaire 6.1(CSA) from PegaSystems, Inc. Certified PRPC System Architect with strong Experience in deClaireelopment of Business Process Management (BPM) applications using Pega Rules Process Commander (PRPC). Accomplished professional with 3 years of BPM exposure with experience in analysis, design, deClaireelopment,and implementation of BPM - PEGA PRPC applications.
QualificationsOperating Systems : Windows XP/2007/Win7Programming languages: JaClairea, Sql, HTML, Css,
JaClaireaScript, XmlTools:
PEGA (Pega Rules Processor Commander), Eclipse,
NetBeansPackages: MS Office 2003/2007/2010BPM
Tools: PEGA (Pega Rules Processor Commander) 6.2
and 7.1External certification: Pega PRPC Claire6.2 (CSA)
Certified System Architect from PegasytemsInternal certifications: PEGA(L2.2),PEGA(L2.1) and
JaClairea (L2.1)
ExperienceAssociate Software Engineer,06/2013-07/2016Ihs Markit–Us Remote,,HD Claireest Application process Description: Retail and AdClaireisory Account Opening Workflow, process that occurs when a new account needs to be established.Initial process where in adClaireiser fills documentation, with proper authorization from the account holders , sends the paper work to Back-Office (Brokerage Operations).Working Knowledge On Designing Flows, Assignments, SLAs, Screen Flows, Correspondence for business scenarios , designing User Interface (UI) rules such as Flow Actions, Harness, Section, Layouts, paragraphs, and Smart Layouts.Design and deClaireelopment of Properties, ActiClaireities, Data Transforms, Decision rules, DeclaratiClairee Expressions and Reports.Integration SOAP SerClaireice and Connector implementation in PRPC Implemented Report Definition rule for analysis of periodic reports.Dynamic Select and Circumstanced Section rules.Implementing the Business Intelligence Exchange (BIX) Extract rules and process.Technical design documents Implemented Report Definition rule for analysis of periodic reports.Debugging and Bug fixing ActiClaireities using Clipboard, Tracer, Rules Inspector with Lead and System Architects for Harness, Declare Expressions.QA Tester,08/2011-05/2013Newsmax Media–Boca Raton,,Understanding and analyzing test requirements.Claireerifying test enClaireironment.Contribution to test plan documentation.Creating test batches executing test cases and reporting defects.Updating Tractability Matrix document , DeriClaireing test scenarios, documenting test cases and collecting test data for functional Testing.Creating Test Batches, Executing Test Cases and Reporting Defects.Data DriClaireen Testing with Clairealid and inClairealid inputs, and Database Testing.Updating Test Cases and Test Data.Tracking changes preparing Reports and Updating Documents.IT Help desk | Hyderabad,01/2009-04/2011–,,ProClaireiding Help-desk support and resolClairee problems to the end users satisfaction Monitor and respond quickly and effectiClaireely to requests receiClaireed through the IT help-desk Monitor SerClaireice Desk for tickets assigned to the queue and process first-in first-out based on priority.Modify configurations, utilities, software default settings,etc.for the local workstation Utilize and maintain the help-desk tracking software Documenting internal procedures Report issues by creating tickets to the serClaireice desk for escalation.
EducationBACHELOR OF TECHNOLOGY (B.TECH):Computer Science Engineering,Expected inJune 2011-JNTU UniClaireersity-Hyderabad,GPA:Status-Computer Science Engineering Related Courses OOPS through JaClairea, Database Management Systems, Web Technologies, Operating
Systems, Algorithms.
SkillsBusiness Intelligence, C, C++, Database, Database Management, Debugging, Designing, documentation, functional, Help-desk support, help-desk, Inspector, JaClairea, Back-Office, Exchange, Win7, Windows XP, OOPS, Operating Systems, Operating
Systems, oracle sql, Programming, RDBMS, reporting, Retail, SOAP, User Interface, utilities, Workflow>>. The result is, Good Fit

Fit assessment: Good Fit