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: <<SummaryDetail-oriented Instrumentation Technician focused on actively being a
part of an industry oriented corporation where I may use my knowledge,
experience and capabilities to promote company goals and continue
growing professionally.
HighlightsAC/DC Circuits, pneumatic and hydraulic systemsTroubleshoot and
calibrate instrumentationProficient in reading and understanding P&ID's, loop sheets, and various one line wiring diagrams from vendorsStrong troubleshooting ability to resolve electrical & mechanical defectsExperienced in troubleshootingExperience in Point to point checks, loop checks, and troubleshootingExperience in Startup & Pre-commissioning/CommissioningInstrumentation Experienced in industrial equipment repair AC/DCKnowledge of Industrial wiring and controlsExperience in troubleshooting PLC'sAbility to diagnose equipment failures to determine cause
ExperienceLead Marine Electrical Technician,07/2013toCurrentThe Louis Berger Group Inc–Palm Beach,FL,Installation, assembly, calibration and repair of marine instrumentationQuality control on electrical wiring and termination throughout theentire vesselLead role of inventory processing and warehouse shipping andrecievingReceive work packages and distribute amongst colleaguesCarefully organize, analyze and prepare technical data reports to ensure proper workflow and productivityMaintain safety by verifying compliance and assuring proper factory testingInspect precision machine parts using process meters, height gauges and optical comparatorsPrepare structural framing drawingsTroubleshoot,diagnose and correct electrical problems in the power distribution, electrical equipment and lighting systemsElectrical Technician,04/2008to07/2013Aimbridge Hospitality–Fishkill,NY,Organize work packages for the programs of constructionPreventative maintenance of lighting panel equipment in various buildings throughout the cityMaintain organization of 6 man crew working on alarms and water control systemsInterpret electrical and mechanical schematics, blueprints and diagramsDiagnose equipment malfunctions and completed repairs to restore equipment and maintain uptimeRepair electrical equipment using hand and power tools and testing and diagnostic equipmentCollaborate with city staff on testing of prototypes and modified instrumentsKeep permits, isolation tags and logs current at all timesVerify that all equipment was certified and meet city and regulatory requirementsRead and work from electronic blueprint drawingsUse safety and environmental tools, HSA/HSA,including 4-point check, OBS cards and PTWDirect city maintenance cost efficiency based on space and power allocationElectrical Mechanic,02/2001to04/2008Luis Muños Marín Airport–City,STATE,Walk down East Wing of Airport units for inspectionsCreate daily data log that entail direct system faults and relevant information for repairsCoordinate and distribute PM's to group of 8 for adequate corrective maintenance of equipment and electrical systemsTroubleshoot and repair aircraft battery chargerAssemble and test airplane potable water systemPreventative maintenance on conveyor belt for baggage claim on West wing of the airport.Identify, install, adjust, verify, calibrate and test operation of power systems, electrical systems, circuitry,
portable electrical equipment in accordance with state and federal electrical codes and ordinancesTroubleshoot, diagnose and correct electrical problems in the power distribution, electrical equipment and lighting
systemsRun cable tray and conduit above and underground according to specified work plansKeep daily documentation and Job Safety AnalysisActive participation in safety program that ensured safety
for all personnel, plant equipment and surrounding environmentsInterpreted electrical and mechanical schematics, blueprints and diagramsRepaired electrical equipment using hand and power tools and testing and diagnostic equipmentReviewed line drawings to locate and splice buried power cablesTroubleshoot electrical circuitsTroubleshoot diagnose and correct electrical problems in the power distribution, electrical equipment and lighting
systems and perform same duties as prior jobs.
EducationAssociate of Science:,Expected intoAutomeca Technical College-Bayamón,PRGPA:Escuela de la Comunidad Nicolás Sevilla, Toa Alta PR
CredentialsUp to date TWIC cardMember of the Association of Reciprocal Safety CouncilsOSHA 10 Training>>. The result is, No Fit

Fit assessment: No Fit