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: <<SummaryRecent graduate from Nucamp Coding Bootcamp with excellent research, technical and problem-solving skills. Detail-oriented and able to learn new technology quickly. Ambitious, career-focused job seeker, anxious to obtain entry-level Python Developer/DevOps position to help launch career while achieving company goals.Experience working with different Software Development Life Cycle (SDLC) strategies in view of Agile, Scrum, and Waterfall Model.Strong Skills in Object Oriented Programming (OOP) Concepts, Object Oriented Design (OOD) Analysis, UML modeling and Design Patterns.Good knowledge on OOP (Objective Oriented Programming) like Inheritance, Polymorphism, Encapsulation and Abstraction.Good knowledge on Django, Flask.Good knowledge on cloud like AWS, Azure and Google cloud.Good knowledge on advanced Python like Lambda, Recursive Functions, Iterators, Generators.Design, Implement and test services experience in Microservice Oriented ArchitectureGood knowledge developing Front End web applications using HTML, CSS.Good knowledge Waterfall, Agile and Scrum Software development methodologies.Strong problem-solving, organizing, communication and planning skills, with ability to work individually and team environment.Self-motivated, able to set effective priority to achieve immediate and long-term goals and meet deadlines.Good organizational, interpersonal, and communications skills with flexibility.
SkillsPostgreSQL/OracleTesting and deploymentHTML and CSSPythonGitDjango/FlaskSplunkMultitasking
Experience05/XXX1to04/XXX2Software QA EngineerAmrock–Phoenix,AZ,Detail-oriented documentation and user guides to sport issues or discrepancies to align with features and comply with standards.Effective and clear communication with developers or any stakeholders regarding non-compliance in existing code with update to compilers and evolving standards of best practice in Java and Python.Good time management to perform meta-analysis of past test results to screen for weaknesses program architecture and suggest redesign of architecture, design where advisable.Collaborated with developers and technical support representatives in identifying bugs to determine appropriate team to consult for resolving issue.Conducted debugging new and updated applications through review of event logs using Splunk and recommended solutions.Reviewed application reports submitted to product owner and technical support representatives for triage.Worked with Agile and Scrum methodologies to accomplish project milestones and ensure to be productive and developed plans to meet deadlines.Ability to wrote quality test plan detailing objectives and test process to manual test cases for the team use for maximum productivity.Monitored and facilitated bug resolutions to optimize application.Collaborated with UAT team to complete timely tests and facilitate smooth product releases.Tested functionality, performance and compliance of each application using different testing tools against design specifications to maintain development standards.Created and maintained database of common and known testing defects.Met project scope and delivery date by planning optimal testing schedules.Created and optimized automated testing tools for repetitive tasks.Completed unit and regression tests on application and individual modules.Produced test scripts for new automated application testing rounds.03/2016to10/2018Java DeveloperCaterpillar–Pomona,MO,Used Hibernate ORM to integrate with business application with Oracle Database where Hibernate template is used to implement business logic.Consumed Web Services by implementing Spring REST support for development of RESTful Web services.Developed stored procedures, Triggers and functions in Oracle to process the trades using PL/SQL and mapped it to Hibernate Configuration File and also established data integrity among all tables.Developed Hibernate mapping files for the Object Relational Mapping while configuring Hibernate.Developed the entire application implementing MVC Architecture integrating JSP with Hibernate and Spring frameworks.Developed test cases using JUnit for unit testing as well as integration testing.Developed Hibernate mapping files for the Object Relational Mapping while configuring Hibernate.Developed the entire application implementing MVC Architecture integrating JSP with Hibernate and Spring frameworks.Developed MicroServices for different level of layers in flow of network.Accessed stored procedures and functions using JDBC Callable statements.Wrote and executed various SQL Queries and PL\SQL programs to retrieve the data from the database Oracle.Used Log4j, JUnit and developed unit test cases to monitor the application functionality.Used Tomcat as a server to deploy the application.
Education and TrainingExpected in08/XXX2toto:Backend, SQL And DevOps with PythonNucamp Coding Bootcamp-Remote,GPA:Expected in10/2015totoBachelor of Science:Applied ComputingGlyndwr University-London, UK,GPA:>>. The result is, Good Fit

Fit assessment: Good Fit